RE: [PHP] LIsting all the Members who have not loged in for 60 days ...
| From: | John W. Holmes | Date: | Wed, 19 Mar 2003 12:51:45 +0000 |
| Subject: | RE: [PHP] LIsting all the Members who have not loged in for 60 days ... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-140276@lists.php.net to get a copy of this message | ||
> $lastDate is a unix time stamp in mySql ... how can i list ONLY the
users
> who have not logged in for 60days?
SELECT name FROM table WHERE FROM_UNIXTIME(lastDate) < CURDATE() -
INTERVAL 60 DAY
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/