Re: query works in mysql, but not from php
| From: | Steve Cayford | Date: | Mon, 19 Nov 2001 23:13:28 +0000 |
| Subject: | Re: query works in mysql, but not from php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-75178@lists.php.net to get a copy of this message | ||
You don't need to put in the final semi-colon when running a query from php. Take that out and you should be fine.
-Steve
On Monday, November 19, 2001, at 04:58 PM, Olav Drageset wrote:
Hi $sql = "SELECT user FROM persons WHERE user = '$firstName' and domain = '$domainName' ; "; $result = mysql_query($sql,$connection ) or die(mysql_error());Calling above lines from php returns: You have an error in SQL syntax near ';' at line 1Issuing the command SELECT user FROM persons WHERE user = 'fred' AND domain = 'company.net' ; in mysql give a proper result. Can anyone explain what might be causing the error??? regards Olav -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net