this gives no result yet if I write$querynew = "SELECT DISTINCT recoentryid FROM businessdetails WHERE recoentryid IN('1','73','20','39','40','41','48','50','71','72') AND (city IN('queretaro') OR city LIKE '%queretaro%')
I get Array ( [0] => 58 [1] => 67 [2] => 73 ). And if I write:SELECT DISTINCT recoentryid FROM businessdetails WHERE (city IN('queretaro') OR city LIKE '%queretaro%')
I get Array ( [0] => 73 )SELECT DISTINCT recoentryid FROM businessdetails WHERE recoentryid IN('1','73','20','39','40','41','48','50','71','72')
Therefore by my logic the first statement above should give Array ( [0] => 73 ) but it gives nothing..... why?