Comparing values help

[coupe-r]

Hey Guys,

 

I have a strtotime() variable inserted into the DB, which serves as an expiration date.  I want to alert the user 7 days before expiration.

 

$next_week = strtotime("+1 week");

 

SELECT COUNT(lease_end_int) FROM tenants WHERE lease_end_int < ' ".$next_week." '

 

lease_end_int is stored as a INTEGER(10) in the DB.. Apparently this is not working.  Any thoughts?

[TeddyKiller]

If the expiration is in the db then $row['expiration'] is the expiration in this case.

$expiration = $row['expiration'];
$expiration -=  7 / 24 / 60 / 60;
if(time() > $expiration) {
    if(time() < $row['expiration']) {
        echo 'You have not reached the expiration date yet!';
    }
}

[JustLikeIcarus]

Why not just store the value as an actual mysql date instead of a unix timestamp?

[coupe-r]

OK, im now storing the dates as yyyy-mm-dd.  Now, how can I set a variable that is always 7 days ahead of the current date?

[JustLikeIcarus]

Use mysql's function DATE_ADD(CURDATE(),INTERVAL 7 DAYS)

[coupe-r]

I just found

 

$next_week = date('Y-m-d', strtotime("+7 days"));

 

Does the same thing.  Thanks for replying.