RE: [PHP-DB] Variables in MySQL Insert Queries

If this is an exact copy of your script, then you've surrounded each variable name in the VALUES(...) with back-ticks. Why? -----Original Message----- From: plague [mailto:plague@freeze.com] Sent: Friday, August 24, 2001 12:57 AM To: php-db@lists.php.net Subject: [PHP-DB] Variables in MySQL Insert Queries I am using this code to connect to my database and insert form data from a user: $connect = mysql_connect("myhost","user","pass") or die (" not connected"); @mysql_select_db("dbname"); $sql="INSERT INTO tablename (id,first,last,age,email,sfuser,sfship,icq,ac,loca,ref) Values(,$first,$last,'$age',$email,$sfuser,$sfship,$icq,$ac,`$ loca,$ref`)"; echo (mysql_affected_rows()?"success":"failure"); mysql_close($connect); The script returns "success" except for it doesn't insert the data ( from a form ). The age column is BLOB, not INT. I would really appreciate the help of someone, as this has really stumped me. Thanks, plague -- 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