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());

How can I fix this problem?

Don't use any keyword or reserve name as field or table name. Rename the order. — Karthik
– Karthik, Commented May 26, 2010 at 5:16

Peter Mortensen · Accepted Answer · 2011-05-14 12:03:35Z

7

In SQL order is a reserved word. Instead use:

INSERT INTO `order`

edited May 14, 2011 at 12:03

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered May 26, 2010 at 5:13

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jacob Relkin · Accepted Answer · 2010-05-26 05:19:09Z

3

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.

edited May 26, 2010 at 5:19

answered May 26, 2010 at 5:13

Jacob Relkin

163k34 gold badges351 silver badges321 bronze badges

Comments

Galen · Accepted Answer · 2010-05-26 05:14:17Z

2

Try putting ticks around order

`order`

answered May 26, 2010 at 5:14

Galen

30.2k9 gold badges75 silver badges90 bronze badges

Comments

Vimard · Accepted Answer · 2010-05-26 05:17:22Z

-3

You forgot "$connection"

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

answered May 26, 2010 at 5:17

Vimard

1,2598 silver badges8 bronze badges

1 Comment

Joseph Over a year ago

Col. Shrapnel is correct. The fact that he is getting a MySQL error shows that the connection is already established. The mysql_query() function uses an already established connection by default if one is not specified. The connection is not an issue. Read the manual -> us2.php.net/manual/en/function.mysql-query.php

Collectives™ on Stack Overflow

INSERT INTO error MySQL/PHP

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related