Re: [PHP] PHP SQL Code
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] Sent: Sunday, March 02, 2003 7:46 AM Subject: [PHP] PHP SQL Code 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 from_unixtime(unix_timestamp(now())-(15760*60)) AND sActive = 'Y' ORDER BY sUpdated DESC; This don't quite work .. Any suggestions? -- Philip J. Newman. Head Developer [EMAIL PROTECTED] +64 (9) 576 9491 +64 021-048-3999 -- Friends are like stars You can't allways see them, but they are always there. -- Websites: PhilipNZ.com - Design. http://www.philipnz.com/ [EMAIL PROTECTED] Philip's Domain // Internet Project. http://www.philipsdomain.com/ [EMAIL PROTECTED] Vital Kiwi / NEWMAN.NET.NZ. http://www.newman.net.nz/ [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP SQL Code
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 your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP SQL Code
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 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 your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP SQL Code
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, it's CURDATE(), not CUR_DATE(). Maybe you shouldn't be so quick to rule things out... ---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