View Single Post
  #2  
Old 23rd December 2009, 14:27
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,034
Thanks: 265
Thanked 151 Times in 131 Posts
Default

As usual I always find the answer after posting it here (I've been at this for 2 days now)

The fix is that I need to use brackets () in the WHERE

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

SELECT * 
FROM 				products 
WHERE				(products.Desc LIKE '%$findThis%' products.Title LIKE '%$findThis%')
AND 				category= '$inCategory";
Reply With Quote