PHP mysql多个Select Query无法正常工作

Question

My sql Query is not working. I need to filter a data with Location but it not works. Why this is not working

$sql = "SELECT count(*) FROM entries WHERE location 
IN ('chennai,Bangalore') AND en_id = 'test' AND date(datetime) 
BETWEEN '2015-10-02' AND '2015-10-31'";

Answer 1

You need to update your query

IN ('chennai,Bangalore')

into

IN ('chennai','Bangalore')