Determine missing dates from array

[jwright]

I have an mysql statement that selects all distinct dates between two date ranges. This works great, but is their an easy way to tell which dates are missing from the list of dates I have.

I believe I can get the first and last date from the query using mysql min(date) max(date) but I am not sure how to do the compare to see which dates are missing.

thanks

[andrin]

$arrMyDates = array("2002-02-09", "2002-02-10", "2002-02-14", "2002-02-15", ...)

$timeFrom = strtotime("2002-02-09");
$timeTo = strtotime($("2002-02-23");

$arrDateSpan = array();
for ($n = $timeFrom; $n <= $timeTo; $n += 86400)
{
$strDate = date("Y-m-d", $n);
array_push($arrDateSpan, $strDate);
}

$arrMissingDates = array_diff($arrDateSpan, $arrMyDates);

I think this could work :-)

[jwright]

You think this could work, please it worked like a dream.

Thanks (you saved me some time I was going about it the long way)

[Anon]

Glad it helped :-)