> $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.
sage -
From: "Philip J. Newman" <[EMAIL PROTECTED]>
Subject: [PHP] LIsting all the Members who have not loged in for 60 days ...
| $lastDate is a unix time stamp in mySql ... how can i list ONLY the users
| who have not logged in for 60days?
|
|
| --
| Philip J. Newman.
| He
$lastDate is a unix time stamp in mySql ... how can i list ONLY the users
who have not logged in for 60days?
--
Philip J. Newman.
Head Developer
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
3 matches
Mail list logo