Re: [PHP] PHP SQL Code

2003-03-02 Thread Tim Ward
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]

RE: [PHP] PHP SQL Code

2003-03-02 Thread John W. Holmes
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

Re: [PHP] PHP SQL Code

2003-03-02 Thread Philip J. Newman
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

RE: [PHP] PHP SQL Code

2003-03-02 Thread John W. Holmes
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,