Date Compare

[Anon]

Does anyone know a quick date compare for two dates? I want to determine if a date stored in MySql is 90 days ago, or more, when compared to today's date.

I can do this, but I was hoping to get a shorter version than what I came up with you.

Thanks for any help

[Anon]

use MySQL's UNIX_TIMESTAMP() function to pull out your date and then do:

<?
if (time () - $mysql_date > 7776000) {
echo 'This date is older then 90 days';
}
?>

note: 7776000 is the number of seconds in 90 days