Calendar error - can anyone help

Dear all I am trying to create a basic calendar of events and all is working except for the following error: I have a mySQL database with the following fields: id - startdate - endate - title - event I am using the followuing command to select the dates that are booked and colour code the relevant cells of the calendar: /snip $sql_currentday = "$year-$month-$zz"; $eventQuery = "SELECT title FROM prestigecal WHERE '$sql_currentday' BETWEEN startdate AND enddate;"; $eventExec = mysql_query($eventQuery); while($row = mysql_fetch_array($eventExec)) { if (strlen($row["title"]) > 0) { echo "<td bgcolor=\"red\" valign=\"middle\" align=\"center\"><font size=\"1px\" face=\"Verdana\">$zz</font></td>\n"; $result_found = 1; This seems to work and populates the calendar with the correct colours but only if the dates have the fist figure the same e.g. start date = 2002-12-16 end date = 2002-12-19 will populate the cells correctly (i.e. 16 / 17 / 18 / 19) But if the dates are as follows: start date = 2002-12-16 end date = 2002-12-20 it populates the correct dates again (i.e. 16 / 17 / 18 / 19 / 20) but also colour codes the date 2002-12-20 for some reason It seems to think that the 2 (of the 20) is a separate date. This also applies when you go into other ranges e.g. 2002-12-25 to 2002-12-30 will populate correctly but also the 3rd can anyone see what is going on with the script and where I have gone wrong. If any further code of mine is required - just ask. I would like to get this finish and then post it to the forum in case anyone else would like it Thanks for your time Ray