Error: Column count doesn't match value count at row 1 help

[funkymonkey]

$sql="INSERT INTO Email (id, Name, Email) VALUES
('$POST[Name]'$POST[Email])";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";

mysql_close($con)
?>

I keep getting an error message "Error: Column count doesn't match value count at row 1". Does anyone know why? I have a table with auto-increments and I am using MySQL 5.1.52.

[NogDog]

You need three comma-separated values if you are going to specify three comma-separated insert columns, e.g.:

$sql="INSERT INTO Email (id, Name, Email) VALUES
(NULL, '$_POST[Name]', '$_POST[email]')";

I don't know if you actually want to use NULL for the "id", but that is often the case if it is an auto-incremented column. Also, to avoid SQL injection errors/attacks, I hope you are properly escaping those $_POST values before using them in the query????

[bradgrafelman]

Also note that what's even more often done (and in fact recommended by the MySQL manual) is to simply omit the AUTO_INCREMENT column (e.g. id) from your INSERT queries altogether.