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 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` = .... 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. 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. Link to comment https://forums.phpfreaks.com/topic/13354-update-query-syntax/#findComment-52322 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.