Having MYSQL Syntax error in PHP when using multiple AND

Question

I have this SQL code

$sql = 'SELECT * FROM images WHERE 
(artist LIKE "'.$artistsearch.'%") 
AND (code LIKE "'.$idsearch.'%") 
AND (name LIKE "'.$namesearch.'%") 
AND (price BETWEEN '.$minprice.' AND '.$maxprice.')';

And I get the error

Invalid query: 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 'AND )' at line 5

However, running the code

SELECT * 
FROM images WHERE artist LIKE '%' 
AND code LIKE '%' 
AND name LIKE '%' 
AND price BETWEEN 0 AND 1000

Works fine in MySQL.

I've tried switching around ' and " and it doesn't work.

Can anyone help me figure out the problem?

Just print out the value of the $sql variable and see what's wrong. — BartoszKP
– BartoszKP, Commented Jan 16, 2015 at 17:25
Are you sure that's the line that's giving you the error? The error message suggests that your SQL includes AND ), and that string doesn't appear in that code — andrewsi
– andrewsi, Commented Jan 16, 2015 at 17:26
The MySQL code you just showed us does not even contain brackets so therefore it cannot be the printout of $sql — chancea
– chancea, Commented Jan 16, 2015 at 17:29

Can Tecim · Accepted Answer · 2015-01-16 17:37:21Z

2

The error says the everything the problem in the last line

AND (price BETWEEN '.$minprice.' AND '.$maxprice.')';

as you can see "AND $maxprice )" part is the problem. Check the $maxprice and be sure it is not empty

answered Jan 16, 2015 at 17:37

Can Tecim

5878 silver badges18 bronze badges

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

Comments

Lightness Races in Orbit · Accepted Answer · 2015-02-28 23:47:14Z

0

if (empty($maxprice)) {
   $maxprice = "some_default_number";
}

$sql = 'SELECT * FROM images WHERE 
   (artist LIKE "'.$artistsearch.'%") 
   AND (code LIKE "'.$idsearch.'%") 
   AND (name LIKE "'.$namesearch.'%") 
   AND (price BETWEEN '.$minprice.' AND '.$maxprice.')';

edited Feb 28, 2015 at 23:47

Lightness Races in Orbit

387k77 gold badges670 silver badges1.1k bronze badges

answered Jan 16, 2015 at 18:08

user254153

1,8935 gold badges44 silver badges88 bronze badges

Collectives™ on Stack Overflow

Having MYSQL Syntax error in PHP when using multiple AND

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related