Syntax Error.

[GB_001]

Hello,

I keep getting a mysql syntax error with this piece of code.

$query = "INSERT INTO Order (FirstName, LastName, Address, NOShirts, NOCaps, NOTickets, Price)
VALUES('$FN', '$LN', '$address', '$Stotal', '$Ctotal', '$Ttotal', '$P')";
mysql_query($query) or die(mysql_error());

 

Thankyou,

GB.

[DarkWater]

What syntax error exactly? =/

[GB_001]

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 (FirstName, LastName, Address, NOShirts, NOCaps, NOTickets, Price) VALUES' at line 1

That's the error.

[AndyB]

order is a MySQL reserved word. You should avoid using reserved words as the names of database tables or fields.

 

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

 

I'd suggest changing the table name, but - if this is a large application already - you could use `backticks` around order and avoid the problem rather than re-write some code.

[GB_001]

Thankyou.

=).