[SOLVED] Querying for expiry dates

[gray8110]

I'm trying to build a query that will check for users with expiration dates that are either in the future or 60 days old. I've played around with a few ways of doing this, but can't make it work in the query. I've been able to do it in PHP after the query, but for a variety of reasons, I'd prefer to have this data come from the query.

 

This is my most recent attempt. $date is the current timestamp formatted to match the datetime format used in the 'DateExpire' row. It appears that MySQL can't compare dates??

//Convert Current Timestamp to datetime format
$date = date('Y-m-d 00:00:00',(time() - 5184000));

//DB Query
$result = mysql_query("SELECT * FROM users WHERE 'DateExpire' > $date ORDER BY wp_users . lastname", $connection);

 

If that's the case, can I have the query convert 'DateExpire' to a timestamp??

 

Ideas?

 

Thanks

[gray8110]

Figured it out... I used DATE_ADD with an interval of -2 months on CURDATE. Works beautifully

 

$result = mysql_query("SELECT * FROM wp_users WHERE DateExpire >= (DATE_ADD(curdate(), INTERVAL -2 MONTH))  ORDER BY wp_users . lastname", $connection);

[aschk]

Yup, or you could use DATE_SUB, it's just the inverse INTERVAL of DATE_ADD