Date Comparaison for a subscribtion system

[cedricm]

I would like to build a user validity system with a subscribtion system working with date.
In MySQL I have a filed(date format) with the date in this format: YYYY-DD-MM.
That date + an expiration time ($expire = 365$abo3600; where $abo is the month (1-12))

I need to compare that result with the today date

$expire = 365$abo3600;
$subscribe = $subscribedate+$expire;
$date = date("Ymd")*1;

if ($subscribe > $date1) {
echo"Abo OK<br>";
} else {
echo"Not OK<br>";
}

What could I do that the small script works????
Thanks for your help

[Mordecai]

You could use the MySQL function TO_DAYS() which will convert any date into days, and then compare.

[cedricm]

I tried to use but could not.

$result = sql_query("select clientactive, userid, aboduree, TO_DAYS(subscribedate) from ".$prefix."_email_download_client_inscription where userid='$login'", $dbi);
list($clientactive, $userid, $aboduree, $subscribedate) = sql_fetch_row($result, $dbi);

$expire = 365$aboduree3600;
$subscribe = $subscribedate+$expire;
$date = date("Ymd")*1;
$date1 = mktime (date("m") ,date("d") ,date("Y"));

if ($subscribe > $date) {
echo"Abo OK<br>$subscribedate, $expire, $date, $date1";
} else {
echo"Not OK<br>$subscribedate, $expire, $date ,$date1";
}

Could you help me with an example thanks

[YappyDog]

$expire = 365$abo3600;

Just curious, how does multilplying 365 times a month times 3600 (??) give you anything meaningful?