INSERT problem... (i think)

stew

there is a problem with the following code somewhere... i have no idea where, it all looks good to me, but its still not working!!!


$SQL = " INSERT INTO meetings (place, from, till, hosts, info, year) VALUES ('$place','$from','$till','$hosts','$info','$year') "; 

$rock = mysql_db_query($db_name, "$SQL", $cid);
if (!$rock) { echo("ERROR"); } else {
echo ("<P><B>New meeting Added - you the man!</B></P>\n"); }

anyone have any ideas?

Pig

Your code looks fine to me. perhaps your $cid is wrong, or maybe a typo in a table or col name.

khaldryck

echo your query and see if there are any quotes that could pose problem.
you could even copy the query to phpmyadmin and execute, so you can know the error.

if you don't find it, copy the query parsed by php in here, and i'll have a check.

also check the names of your cols. sometimes typoes are so hard to find when it's our own code 😉

stew

the error i get i have no idea how to intrepret it... here it is:

"You have an error in your SQL syntax near 'from, till, hosts, info, year) VALUES ('Norwich','2002-05-22','2002-05-24','Som' at line 1"

you can see that the $year variable isn't being inserted, and there is no leading "(" ...
ive checked the colums names and there are no typo's and ive checked everything else... anyone have any idea what the error means?

Pig

echo the $SQL to see what exactly it's choking on.

xblue

rename the column called 'from' (and bookmark the list of reserved words 😉)
http://www.mysql.com/doc/en/Reserved_words.html

khaldryck

yup, that's the problem, you have a field called from, which is a reserved word, change it to something like city_from.