> > > 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
