SacredProductions Posted July 1, 2006 Share Posted July 1, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/13354-update-query-syntax/ Share on other sites More sharing options...
Barand Posted July 1, 2006 Share Posted July 1, 2006 order is a reserved word. Use ... SET `order` = .... Quote Link to comment https://forums.phpfreaks.com/topic/13354-update-query-syntax/#findComment-51671 Share on other sites More sharing options...
SacredProductions Posted July 1, 2006 Author Share Posted July 1, 2006 Whoops.Thanks a bunch. Quote Link to comment https://forums.phpfreaks.com/topic/13354-update-query-syntax/#findComment-51727 Share on other sites More sharing options...
fenway Posted July 3, 2006 Share Posted July 3, 2006 Better yet, rename your column... backticks will get you into lots of trouble. Quote Link to comment https://forums.phpfreaks.com/topic/13354-update-query-syntax/#findComment-52322 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.