MySQL error: You have an error in your SQL syntax;

Asked Jan 24 '16 at 15:19

Active Jan 24 '16 at 15:19

Viewed 33 times

MySQL 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 WHERE orderid='123'' at line 1

this is what I used

$query  = mysql_query("SELECT * FROM order WHERE orderid='123'")or die('<span class="error_span"><u>MySQL error:</u> ' . htmlspecialchars(mysql_error()) . '</span>');

I don't see any mistake in the code, can someone please help me out?

asked Jan 24 '16 at 15:19

Adib

1

It's telling you here `right syntax to use near 'order` - the operative word here being "order". Remember to read errors. See the duplicate it was closed with. – Funk Forty Niner Jan 24 '16 at 15:21
1

ORDER BY is a SQL keyword. Choose another name for that table and you'll do better. – duffymo Jan 24 '16 at 15:21
Or simply wrap `order` in backtips. – cFreed Jan 24 '16 at 15:23
thank you duffymo for clarifying that. – Adib Jan 24 '16 at 20:37

MySQL error: You have an error in your SQL syntax;

0 Answers0