You have an error in your SQL syntax near 'WHERE startdatetime >= "2008-05-1 00:00:00" AND startdatetime <= "2008-05-1 23:5' at line 1 SELECT event FROM WHERE startdatetime >= "2008-05-1 00:00:00" AND startdatetime <= "2008-05-1 23:59:59" and status_id = 2 and eid='a' ORDER BY startdatetime