You have an error in your SQL syntax; check the ...
Posted: Wed Apr 29, 2009 10:38 am
I bow before you. The further pieces of code worked well up till now:
But some moments ago I began getting a strange 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 'lock ) VALUES ('12', '2', 'test', 'test', 'test', '1241015213', '1241015213', '9' at line 1
Please note that other queries run absolutely well, even equivalent INSERT INTO in other scripts, located on the same server, in the same folder, sending commands to the tables in the same database run without any errors as well.
I thank you in advance
Code: Select all
$sql="INSERT INTO forum_question (forums_id, id, topic, detail, name, datetime, last_reply, user_ip, lock ) VALUES ('$f_id', '$id', '$topic', '$detail', '$name', '$time', '$time', '$ip', '$no' )";
$result=mysql_query($sql) or die(mysql_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 'lock ) VALUES ('12', '2', 'test', 'test', 'test', '1241015213', '1241015213', '9' at line 1
Please note that other queries run absolutely well, even equivalent INSERT INTO in other scripts, located on the same server, in the same folder, sending commands to the tables in the same database run without any errors as well.
I thank you in advance