remove the ";" at the end... mysql_query() doesn't need it... since it only executes on atomic command, the ";" is useless..
that's what's causing the error... At 22:58 19/11/01 +0000, 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] _____________________________ . Christian Dechery . . Gaita-L Owner / Web Developer . . http://www.webstyle.com.br . . http://www.tanamesa.com.br -- 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]