Problems with INSERT INTO
Posted: Sun Apr 01, 2007 2:37 pm
i have had some issues with the following code
when i run that with the form, i get this
please help, i'm goin nuts, been at this script for 2 days
Code: Select all
$reservupdate = mysql_query("INSERT INTO reserv (lastname,firstname,#carts,rented,returned,phone,email)
VALUES (".$lastname.",".$firstname.",".$carts.",".$rented.",".$returned.",".$phone.",".$email.")");
if (!$reservupdate)
{
die("Error: " . mysql_error());
}a working example of the error can be found at http://funcartsofcrystalbeach.com/index2?pid=2Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUES (Bartlett,Dennis,4,3/31/07,4/2/07,337-353-3620,dcbartlett
please help, i'm goin nuts, been at this script for 2 days