I'd use ...
WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(sUpdated) 60*60*24*60
but I'm sure someone will come up with something more efficient.
Tim Ward
http://www.chessish.com
mailto:[EMAIL PROTECTED]
- Original Message -
From: Philip J. Newman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
I would like yo show the users in a list that have a date that is more
than
60 days old.
$sql = SELECT * FROM stompers WHERE sUpdated CUR_DATE() - INTERVAL 60
DAY AND sActive = 'Y' ORDER BY sUpdated DESC;
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get
This one returns a 'Could not get Query' warning ... so thats out.
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: 'Philip J. Newman' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 5:31 AM
Subject: RE: [PHP] PHP SQL Code
I would like yo show
I would like yo show the users in a list that have a date that is
more
than
60 days old.
$sql = SELECT * FROM stompers WHERE sUpdated CUR_DATE() -
INTERVAL 60
DAY AND sActive = 'Y' ORDER BY sUpdated DESC;
This one returns a 'Could not get Query' warning ... so thats out.
Sorry,
4 matches
Mail list logo