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
