Jump to content

Archived

This topic is now archived and is closed to further replies.

SacredProductions

Update Query Syntax

Recommended Posts

I am using this simple query to update the order of some articles on a webpage.
[tt]
$sql="UPDATE articles_level0 SET order='$norder' WHERE id='$id'";
mysql_query($sql) or die(mysql_error());[/tt]

I get this error-
[tt]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='1' WHERE id='9'' at line 1
[/tt]
The numbers for order and id are correct. I cannot find the syntax error though.

Any help is appreciated

Share this post


Link to post
Share on other sites
order is a reserved word. Use ... SET `order` = ....

Share this post


Link to post
Share on other sites
Better yet, rename your column... backticks will get you into lots of trouble.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.