MySQL Error - Inserting into Table

Question

I have a little problem inserting into a table, here is the code:

mysql_query("INSERT INTO admin_menu (id, title, type, icon, parent, url, order, append, module) VALUES('', 'powerpoint', '0', 'powerpoint.png', '0', 'powerpoint/config', '0', '0', '0' ) ") or die(mysql_error());

it gives me the following 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, append, module) VALUES('', 'powerpoint', '0', 'powerpoint.png', '0', 'pow' at line 1

Any help would be greatly appreciated, thanks!

sachleen · Accepted Answer · 2012-10-14 20:13:33Z

7

order is a reserved word. Wrap it in backticks

... url, `order`, append,...

You also shouldn't be using mysql_query.

Use of this extension is discouraged. Instead, the MySQLi or PDO_MySQL extension should be used.

answered Oct 14, 2012 at 20:13

sachleen

31.2k8 gold badges81 silver badges75 bronze badges

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

Comments

Nesim Razon · Accepted Answer · 2012-10-14 20:13:36Z

3

you need to use backticks. order is reserved keyword.

mysql_query("INSERT INTO admin_menu (id, title, type, icon, parent, url, `order`, append, module)

answered Oct 14, 2012 at 20:13

Nesim Razon

9,8043 gold badges38 silver badges48 bronze badges

Collectives™ on Stack Overflow

MySQL Error - Inserting into Table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related