> $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.
you can use strtotime()
example, this will subtract 60 days from the variable you assign to it, in
this case it'll subtract it from $lastDate
and go from there.
strtotime("-60 days");
http://www.php.net/manual/en/function.strtotime.php
cheers,
- Sebastian
- Original Message -
From: "Ph
2 matches
Mail list logo