[PHP] query works in mysql, but not from php

[Olav Drageset]

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]