INSERT INTO error MYSQL/PHP

Question

I get this 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 (total, addy, cc) VALUES ('798' , '123 sadf' , '12124123')' at line 1

$total = addslashes(($_SESSION['total']));

$addy = addslashes(($_POST['addy']));

$cc = addslashes(($_POST['cc']));

echo "$total";

echo "$addy";

echo "$cc";

mysql_query("INSERT INTO order (total, addy, cc) VALUES ('$total' , '$addy' , '$cc')") or die(mysql_error());

help plz =]

Answer 1

order is reserved word.

INSERT INTO `order`

Answer 2

The reason why this is failing is because "order" is a keyword in SQL.

You need to put backticks around table names to avoid problems like these.

Answer 3

Try putting ticks around order

`order`

Answer 4

You forgot "$connection"

mysql_query("INSERT INTO order (total, addy, cc) VALUES ('$total' , '$addy' , '$cc')",$connection) or die(mysql_error());