title: MySQL error: You have an error in your SQL syntax;
body: <p>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</p>
  
  <p>this is what I used</p>
  
  <pre><code>$query  = mysql_query("SELECT * FROM order WHERE orderid='123'")or die('&lt;span class="error_span"&gt;&lt;u&gt;MySQL error:&lt;/u&gt; ' . htmlspecialchars(mysql_error()) . '&lt;/span&gt;'); 
  </code></pre>
  
  <p>I don't see any mistake in the code, can someone please help me out?</p>