The following query will not execute
mysql_query("SELECT * FROM order WHERE orderID = 102;");It produces the following error message:
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 WHERE orderID = 102’ at line 2
How can I write SQL that will successfully query this table?
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
Order is a reserved word. Don’t use reserved words as table or field names; or wrap it in the escape characters such as ` for mysql. Personally I just avoid using them as they generally cause more headache than they are worth in the long run.
Example:
mysql_query("SELECT * FROM `order` WHERE orderID = 102;");MORE INFO – you can get more info about reserved word here https://dev.mysql.com/doc/refman/5.5/en/keywords.html
Method 2
Drives me crazy that people assume queries will work, and then don’t even bothering asking the database to explain why things blew up. Try this:
$result = mysql_query("SELECT * FROM order WHERE orderID = 102;") or die(mysql_error());as well, unless there’s more code than what you’re showing above, you HAVE to capture the return value of the query call, since that return value is your result handle, from which you fetch results. Without that statement handle, you’re basically wasting the DB server’s (and your own) time.
Method 3
Try
mysql_query("SELECT * FROM order WHERE orderID = 102;") or die("MySQL ERROR: ".mysql_error());
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0