> I have used strtotime() function in the past, and done this: > > if($time >= strtotime('24 hours ago')) { > $new = "new!"; > } > > with it being in UNIX time stamp .. But now I have a different client > where > the time stamp in mysql is formatted like: > 2002-08-29 10:53:09 > > what function would I use in this case, date() ? If so, how would I do the > same exact thing?
SELECT column - INTERVAL 24 HOUR FROM your_table WHERE ... ---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