Comparing dates

[Omnem]

Hello,

I have two mysql DATA (YYYYMMDD) fields, and i want to compare them with the current date on my webserver. I want the current date to be belong DATE in the interval made by my two mysql fields. (of course i want this done in php)

ie. mysql : 2005-11-05 and 2005-11-21 and i want to know if our current date ( 2005-11-07 ) belongs in our given interval.

I have used several methods but they end up using to much code and i`m sure there is a shorter way.

Thanks for looking and i`m looking forward for your replies.

[tucker]

Here is a script I wrote to do it. Basically it defines the three dates, seperates the dates by the dashes with explode, then compares the dates to see if the current date is greater than or less than the interval dates:

<?php
$currentdate = "2005-11-07";
$date1 = "2005-11-05";
$date2 = "2005-11-21";
$explode1 = explode("-", $date1);
$explode2 = explode("-", $date2);
$explodecur = explode("-", $currentdate);
if ($explodecur[0] > $explode2[0]) {
echo "The date is past the given interval.";
}
elseif ($explodecur[0] < $explode1[0]) {
echo "The date is before the given interval";
}
elseif ($explodecur[1] > $explode2[1]) {
echo "The date is past the given interval.";
}
elseif ($explodecur[1] < $explode1[1]) {
echo "The date is before the given interval";
}
elseif ($explodecur[2] > $explode2[2]) {
echo "The date is past the given interval.";
}
elseif ($explodecur[2] < $explode1[2]) {
echo "The date is before the given interval";
}
else {
echo "The date is within the given interval.";
}
?>

-tucker-