Topic: LIKE makes query ignore other variables

[Aravona]

I have no access to what mySQL is being used, as I do not host the website myself and my friend has no clue. I believe it to be 5.1

I've got a site which needs to query the database for a search function, currently it uses the following:

Code: [Select]

"SELECT * FROM ver_pro WHERE name LIKE '%$srch2%' OR prCode LIKE '%$srch2%' OR price LIKE '%$srch2%' AND active = '1' AND mID='2' ORDER BY prID"
However the LIKE causes the query to ignore the mID restriction.

I've been trying all day to figure this out to no avail, any help would be greatly appriciated!

Aravona

[Alex]

Try:

Code: [Select]

SELECT * FROM ver_pro WHERE (name LIKE '%$srch2%' OR prCode LIKE '%$srch2%' OR price LIKE '%$srch2%') AND active = '1' AND mID='2' ORDER BY prID

[Aravona]

Thanks, can't believe I didn't pick up on that! I guess I've just been staring at it way too long

[Alex]

No problem. By the way, can you mark the topic as solved by clicking the button on the bottom left.