On Lun 19 Nov 2001 19:58, 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
Through away the semicolon (;), that only tells the MySQL interpreter that the quiery should be executed. In PHP, each call to the query function executes it. Saludos... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | [EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral ----------------------------------------------------------------- -- 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]