MySQL query issue : WHERE clause

Question

I recently switched from windows (movamp) to linux (lamp), and i have an issue (syntax error) with a query and i can't figure out why. Here is the query and the error msg I get:

"SELECT * FROM products WHERE trash='false'"

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 '\'false\'' at line 1SELECT * FROM products WHERE trash='false'

I always wrote my queries with that syntax, and i never had problems.

I used to run my code on windows (php 4.1.22 mysql 5.2.11) and used mysql_query() function, and the code worked just fine. Now I use(php 7.0.8 - mysql 5.7.16) and use mysqli_query() function to execute queries

have you tried without the single quotes? It seems like you trying to escape the single quotes and this is causing the issue — Marius Brits
– Marius Brits, Commented Dec 7, 2016 at 7:40
use false if the value is supposed to be string or use just false if the value is supposed to be boolean — Arjan Shrestha
– Arjan Shrestha, Commented Dec 7, 2016 at 7:44

Álvaro González · Accepted Answer · 2016-12-07 09:38:36Z

1

Your syntax error shows some bogus backslashes that are not present in the query, as if you are actually running this:

SELECT * FROM products WHERE trash=\'false\'

Not having even a full PHP statement to inspect we can only speculate, and my guess is that —since you are upgrading from a really ancient PHP version— you might be facing some issues with magic quotes. That "feature" no longer exists so nothing in the server can be injecting backslashes automatically so it must be your code the one that's intentionally doing it.

Said that, PHP/4 was superseded by PHP/5 in 2004 (that's like 12 years) and a lot has changed on the way to PHP/7: migration is going to be harder than just dropping the code in the new server.

edited Dec 7, 2016 at 9:38

answered Dec 7, 2016 at 9:17

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jaithra Bopanna KK · Accepted Answer · 2016-12-07 08:40:37Z

0

Try removing the single quotes , or try reversing the single and double quotes . IF nothing works use a variable with false value.

answered Dec 7, 2016 at 8:40

Jaithra Bopanna KK

115 bronze badges

Comments

Rossitten · Accepted Answer · 2016-12-07 08:45:45Z

0

"SELECT * FROM `products` WHERE `trash` ='false'"

try this (though your case should also work)

also try to remove the double quotes if you are trying to run SQL query in PHPMYadmin or likes.

answered Dec 7, 2016 at 8:45

Rossitten

1,1661 gold badge17 silver badges34 bronze badges

Comments

drafat · Accepted Answer · 2016-12-07 13:19:16Z

0

I would like to thank you all for your answers and your comments. You helped me figure out what the problem was : the entire query string was beeing escaped instead of only the data tha needed to ne escaped.

I feel dumb 😁 . This was obvious.

Anyway. Thank you a lot for your contibution.

answered Dec 7, 2016 at 13:19

drafat

233 bronze badges

Collectives™ on Stack Overflow

MySQL query issue : WHERE clause

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related