This statement gives me 3 results echoed in the array at the end : Array ( [0] => 58 [1] => 67 [2] => 73
This gives me one result:Array ( [0] => 73 )SELECT DISTINCT recoentryid FROM businessdetails WHERE (street IN('queretaro') OR street LIKE '%queretaro%' OR townborough IN('queretaro') OR townborough LIKE '%queretaro%' OR city IN('queretaro') OR city LIKE '%queretaro%' OR county IN('queretaro') OR county LIKE '%queretaro%' OR state IN('queretaro') OR state LIKE '%queretaro%' OR postcode IN('queretaro') OR postcode LIKE '%queretaro%') Array ( [0] => 58 [1] => 67 [2] => 73 )
yet when I put them together I get no results (should print 73 (common in both statements).SELECT DISTINCT recoentryid FROM businessdetails WHERE recoentryid IN('1','73','20','39','40','41','48','50','71','72') Array ( [0] => 73 )
Can anyone please shed some light on it. thank you...SELECT DISTINCT recoentryid FROM businessdetails WHERE recoentryid IN('1','73','20','39','40','41','48','50','71','72') AND (street IN('queretaro') OR street LIKE '%queretaro%' OR townborough IN('queretaro') OR townborough LIKE '%queretaro%' OR city IN('queretaro') OR city LIKE '%queretaro%' OR county IN('queretaro') OR county LIKE '%queretaro%' OR state IN('queretaro') OR state LIKE '%queretaro%' OR postcode IN('queretaro') OR postcode LIKE '%queretaro%') Array ( )