MySQL Query Problems

[millesm]

I'm getting incorrect results from a query when run under PHP vs running it in phpMyAdmin.

Query is:

SELECT * FROM cart
where Category like '78'
and (name like '%fish%'
or description like '%fish%'
or keywords like '%fish%')

I would expect to get no rows returned under PHP, but I get 2.
Under phpMyAdmin I get the expected no rows found.

Php statement which generates the above exactly is:

$query_count = "SELECT * FROM cart
where Category like '$title_row[Id]'
and (name like '%$search%'
or description like '%$search%'
or keywords like '%$search%')";

Any ideas why this is not working in my PHP page?

thanks

[xblue]

if you get more results than you want, possibly $search doesn't contain anything.

simply echo the query.

if $search is coming from user input, you might need to use $GET['search'] or $POST['search'].

[millesm]

All variables are being populated correctly as you can see in the first complete statment.

This statement was produced via echo of $query_count.

When I cut and past it into phpMyAdmin it works as expected, but when it is executed in PHP, it returns 2 rows that I should not be getting.

It is as if the AND (......) is being treated as an OR in PHP.

[millesm]

Is anybody able to give me any guidence with this problem?