sql给出错误[重复]

Question

This question already has an answer here:

• Syntax error due to using a reserved word as a table or column name in MySQL 1 answer

I have tried these SQL querys:

$sql = "SELECT * FROM `order` WHERE `KLANT_ID` = \'1\'";
$sql = "SELECT * FROM order WHERE KLANT_ID = '1'";
$sql = "SELECT * FROM order WHERE KLANT_ID = 1";

If i run these i get this 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 KLANT_ID='1'' at line 1

I normally did this query with 1 being a variable $id but that gave the same error. Also deleting `` these from order and KLANT_ID does not work. Also when i change this part : \'1\' to '1' it does not work

This is al done with PHP MYSQLI and PHPMYADMIN database

Thank you

</div>

Answer 1

You are manually escaping the single quotes in your query, while that is not needed (because you use double quotes for the variable).
You need to undo the escaping.

$sql = "SELECT * FROM `order` WHERE `KLANT_ID` = '1'";

Also, use this function to escape, not just backslash the variable.