[SOLVED] Simple Syntax Error

[kpetsche20]

Hey, I keep getting this error for my insert query, it's driving me nuts because I can't find any problem.

mysql_query("INSERT INTO order (userid) VALUES('".$userid."')") or die(mysql_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 'order (userid) VALUES('126')' at line 1

[sKunKbad]

$sql ="INSERT INTO order (userid) VALUES ('" . $userid . "');"

mysql_query($sql)OR die(mysql_error());

[priti]

Hey, I keep getting this error for my insert query, it's driving me nuts because I can't find any problem.

mysql_query("INSERT INTO order (userid) VALUES('".$userid."')") or die(mysql_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 'order (userid) VALUES('126')' at line 1

 

Is your userid datatype is varchar ... if not please remove '' i.e '123' instead it should be 123 if not numeric .

 

[kpetsche20]

It still give me the same error when I use the code you just sent.

[kpetsche20]

The database is setup fine, it's a mysql_query() error

 

Hey, I keep getting this error for my insert query, it's driving me nuts because I can't find any problem.

mysql_query("INSERT INTO order (userid) VALUES('".$userid."')") or die(mysql_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 'order (userid) VALUES('126')' at line 1

 

Is your userid datatype is varchar ... if not please remove '' i.e '123' instead it should be 123 if not numeric .

 

[sKunKbad]

so, "order" is the name of your table?

 

userid is a field?

 

try running your sql directly on the database through phpmyadmin or mysql itself.

[kpetsche20]

I think that "order" cannot be the name of a table in a mysql database, when I changed the table name and it works now.

[priti]

The database is setup fine, it's a mysql_query() error

 

Hey, I keep getting this error for my insert query, it's driving me nuts because I can't find any problem.

mysql_query("INSERT INTO order (userid) VALUES('".$userid."')") or die(mysql_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 'order (userid) VALUES('126')' at line 1

 

Is your userid datatype is varchar ... if not please remove '' i.e '123' instead it should be 123 if not numeric .

 

 

I will also suggest you to run your query in PHPMyAdmin interface.

 

what happen if you run following query in sql mode.

 

INSERT INTO order (userid) VALUES(123);

[redarrow]

just change the database setting from  varchar to a int