> $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/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
