12 Topics
|
|
I have the following script which successfully finds the values for $payer_email, reminder_date and sub_expire_date, however where I am having trouble is when I apply a WHERE condition to the SELECT. The condition I am trying to apply is the commented out line at the end of the SELECT. The … |
|
Hello, how to write url alias in nginx ? I have create the url alias before in apache. But, now the web is moved to nginx. This is the url alias config (using .htaccess) that I have write in apache : RewriteEngine On # Turn on the rewriting engine RewriteBase … |
|
Hi there, My question isn't strictly about programming, it's primarily a question of how to approach my problem with the tools I have. I am building a website where a user can sign up and create their own profile/portfolio so to speak. Let's say this is `mysite.com`. Say Joe Bloggs … |
|
I have a C++ program with a main routine which reads arguments from command line: int main(int argc, const char *argv[]) In my system I have defined some aliases in my bash environment which abbreviates directory names. Example: alias dst='home/username/Documents/test' alias src='home/username/Download/test' My program is called "dircopy" and I want … |
|
When using emails as usernames you want them to be unique over your table, but this can be a problem if you consider a GMail account, because of their [username](https://support.google.com/mail/answer/12096?hl=en) [policy](https://support.google.com/mail/answer/10313?hl=en). They allow: * dots * digits * letters * plus addressing text by using the `+` sign, i.e. `orange+juice@gmail.com` … |
|
I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- #1066 - Not unique table/alias: 'topics' .i am unable to understand the problem. |
|
mysql Inner join problem I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- 1066 - Not unique table/alias: 'topics' .i am unable to understand the problem. |
|
Hi, I am having trouble with retrieving records on my database. My layout was this.. [CODE]UsersList Username Firstname LastName Role Records TheUser ApprovedBy DateApproved [/CODE] The first text are the table names while the indented once are the field names. I have a table named Records. TheUser and ApprovedBy was … |
|
I’ve created a dynamic page ([I]page.php[/I]) who’s content changes based on the incoming link, specifically by calling a GET on the ID in the URL. So, for example, someone visits [I][url]www.domain.com/page.php?id=310[/url][/I] and the content on the page changes queries the database and returns results for item 310. I’m in the … |
|
I have 2 directories on Mac OS, one is the original directory and the other is an alias of the original directory. I want to list the contents of the aliased directory using shell script. I used the cd command to switch to the aliased directory, but it fails displaying … |
|
Almost every user on this board has an alias that is unique and descriptive. But also, many users create multiple alias to fit in different environment. So my questions for the members here are: 1. What does your name/alias mean? 2. What else would you like to share? 3. Does … |
The End.