[edge]

Some one here who can explain why this query is working fine:

$findThis = "testing";
$inCategory = "cat1";

SELECT * 
FROM 				products 
WHERE				products.Desc LIKE '%$findThis%'
AND 				category= '$inCategory";

It returns the correct info, from cat1.

But when I want to search in more product fields (in this case also the Title), and when I set the inCategory to an other value it still shows the info from cat1

$findThis = "testing";
$inCategory = "cat2";

SELECT * 
FROM 				products 
WHERE				products.Desc LIKE '%$findThis%'
OR				products.Title LIKE '%$findThis%'
AND 				category= '$inCategory";

I have also tested this:

SELECT * 
FROM 				products 
WHERE				products.Desc LIKE '%$findThis%' || products.Title LIKE '%$findThis%'
AND 				category= '$inCategory";

But I get the same results as the 2nd query.

For some reason the AND does not work correct!

Anyone here who can show me what the correct syntax is?