Here is my query i am using:
$sql = "SELECT * FROM leads WHERE referrer_id = 24 AND date_added BETWEEN $date1 AND $date2 AND status_id = 5 ORDER BY id DESC";
My date format is as such 2010-02-01 and the time format of the database is a timestamp, such as 2010-02-01 05:12:25PM. I am not sure if it is this small difference that is making my query fail. The thing is, it does not give me a empty result set error, it just doesn't do anything. I know there are rows that match, but the page stays blank. Any suggestions?