Aravona Posted June 15, 2010 Share Posted June 15, 2010 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: "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 Quote Link to comment https://forums.phpfreaks.com/topic/204863-like-makes-query-ignore-other-variables/ Share on other sites More sharing options...
Alex Posted June 15, 2010 Share Posted June 15, 2010 Try: 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 Quote Link to comment https://forums.phpfreaks.com/topic/204863-like-makes-query-ignore-other-variables/#findComment-1072448 Share on other sites More sharing options...
Aravona Posted June 15, 2010 Author Share Posted June 15, 2010 Thanks, can't believe I didn't pick up on that! I guess I've just been staring at it way too long Quote Link to comment https://forums.phpfreaks.com/topic/204863-like-makes-query-ignore-other-variables/#findComment-1072452 Share on other sites More sharing options...
Alex Posted June 15, 2010 Share Posted June 15, 2010 No problem. By the way, can you mark the topic as solved by clicking the button on the bottom left. Quote Link to comment https://forums.phpfreaks.com/topic/204863-like-makes-query-ignore-other-variables/#findComment-1072461 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.