"Edward Peloke" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> I have a table in a database that holds begin and end dates...I would like
> to select all the begin and end dates for a certain id, then add those
> dates, plus the dates between them to an array...example.
>
> Begin date 2004-07-04
> End date 2004-07-09
>
> I want the array to hold,
> 2004-07-04,2004-07-05,2004-07-06,2004-07-07,2004-07-08,2004-07-09
>
> I would then loop to the next row in the db and continue to add to the
> array. I can't simply add one to the last two characters. What's the
best
> way? I ask becuase I am using a nice php calender script and I want to
> change the background color of the day's cell if it falls between the
begin
> and end dates of the calender. I thought I could just add the dates to an
> array, then use the in array function on each date.
As you only want to check if a certain date falls within the specified time
period, this could be done easier by converting the dates to timestamps:
$start = '2004-07-04';
$end = '2004-07-09';
$check = '2004-07-06'; // the date you want to check
$timestampStart =
mktime(0,0,0,substr($start,5,2),substr($start,8,2),substr($start,0,4));
$timestampEnd =
mktime(0,0,0,substr($end,5,2),substr($end,8,2),substr($end,0,4));
$timestampCheck =
mktime(0,0,0,substr($check,5,2),substr($check,8,2),substr($check,0,4));
if ($timestampCheck >= $timestampStart && $timestampCheck <= $timestampEnd)
{
// do what you want
}
Haven't tested it. Hope it works for you.
Regards,
Torsten Roehr
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
