RE: [PHP-DB] ODBC again

PHP seems to have problems with replacing variable which contain underscores '_' in strings. Change the code to: $result1 = odbc_prepare($conn, "SELECT * FROM PERSONAS WHERE email = '".$v_mail."')"; _____ ~ Richard Allsebrook ~ Applications Developer and Webmaster Easysoft Limited, Thorp Arch Grange, Thorp Arch, Wetherby, LS23 7BA, UK http://www.easysoft.com <http://www.easysoft.com> - http://www.cinema.com <http://www.cinema.com> "A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila." _____ -----Original Message----- From: buitrago.fernando [mailto:buitrago_fernando@hotmail.com] Sent: Thursday, April 05, 2001 7:47 AM To: php-db; buitrago.fernando Subject: FW: [PHP-DB] ODBC again My code is: $conn = odbc_connect("encuneweb","",""); $result1 = odbc_prepare($conn, "SELECT * FROM PERSONAS WHERE email = '$v_mail')"; if (!odbc_execute($result1)) echo "nuevo usuario"; $insertar_persona = "INSERT INTO Personas (Nombre, Apellido1, Apellido2, mail, telefono1) VALUES('$v_nombre', '$v_apellido1', '$v_apellido2', $v_mail)" ); The line number 45 is: The second line ($result1=odbc_prepare......... display the following message: Parse error: parse error in C:\Sistemas\encune_web\registro.php on line 45 Why. Thanks and regards fernando -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

Attachment: [application/rtf]