[RESOLVED] Need help with php/mysql search query

[imc]

Hi! I'm trying to get this search query to work, and, as far as the search goes, it's working perfectly... Except when it gets to the " AND display = 'SHOW' " - It's not following this rule.. It is showing anything, regardless of whether the display field is set to SHOW or HIDE...

$sql=mysql_query("SELECT * FROM plants WHERE lname LIKE '%$squery%' OR cname LIKE '%$squery%' OR pdesc LIKE '%$squery%' AND display = 'SHOW' ORDER by lname,cname ASC LIMIT 0,30 ");

And it's not returning any errors... Just performs the search and shows all records, rather than just the ones defined to SHOW in the display field...

What am I doing wrong?

Thanks in advance for the help!

imc

[Sxooter]

You need to wrap your ORed statements inside a pair of parens.

WHERE
(
lname LIKE '%$squery%'
OR cname LIKE '%$squery%'
OR pdesc LIKE '%$squery%'
)
AND display = 'SHOW'

[imc]

Thank you so much! That fixed it, and it is now working flawlessly!

Thanks again!

[bogu]

Don't forget to mark this thread as RESOLVED ...