Hi guys,

I have this sql statement that is trying to insert data from some fields

$con = mysql_connect("xxx","xx","xx");
if (!$con)
die('Could not connect: ' . mysql_error());
mysql_select_db("xxx", $con);
$sql="INSERT INTO guests (guest_name, guest_email) VALUES";
if (!mysql_query($sql,$con))
die('Error: ' . mysql_error());
echo "record added";

but it returns the error

Error: 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 '' at line 1

Edited 3 Years Ago by happygeek: fixed formatting

Print your query and execute it in mysql console/phpmyadmin.. Also show us the query ..

not sure what you mean here. please elaborate?

$sql="INSERT INTO guests (guest_name, guest_email) VALUES";

echo $sql;

What does it print ?

oh i understand now.

it prints :
INSERT INTO guests (guest_name, guest_email) VALUES

Thats it ? Its not entering the for loop ? Well, then there is the problem. Check your for loop and see if the values are being posted.

This article has been dead for over six months. Start a new discussion instead.