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