What is the problem with SQL query to MySQL in PHP?

Question

PHP

Query after escaping:

SELECT * FROM test WHERE field1=\'test321\' AND field2=\'test123\';

But after query() errorCode == 42000. Where is the cant with the syntax?

Answer 1

The cant is in the user, because he shields not what is needed, and not what is needed.
Read about mysql_real_escape_string()and fix your code.

Answer 2

The problem is with the user who escaped this request.
To solve the problem, you need to send the user to learn the rules for compiling requests.