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 1 > > Issuing 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]