Im trying to grab all records that match the month from:
$eventid = '2007-05-11';
Seems to bring back zero rows when there are 2 rows iin he database matching the 5th month.Code:$sql = mysql_query("SELECT id, firstname, lastname, phone, cellphone, email, starttime, finishtime, event FROM calendar WHERE MONTH(starttime) LIKE '".$eventid."%' ORDER BY starttime ASC");
Have I got it all wrong?