RE: [PHP] how do i determine what posting is new??

I guess that it is not hard at all. function yesterday($fromDb) { if (time() > $fromDb+84600) return '[new]'; } then in the script: echo "$record['name']"; echo yesterday($record['time']); 2: your way is ok, I thikn it should work ... Cheers, Maxim Maletsky -----Original Message----- From: Sandeep Hundal [mailto:sandeep_wde@yahoo.com] Sent: Wednesday, November 29, 2000 1:23 PM To: php-general@lists.php.net Subject: [PHP] how do i determine what posting is new?? Hi list, I'm making a kind of a message board for which i need to have a [new] against the ones which posted in the last day. I put $time into the database, as a unix timestamp. all i need is a function which returns a variable. So if $time (after querying it out of mysql) - 84600 * 1 is is leser than current time, it prints out [new]. also, how do i only query out of the database stuff posted in the last 14 days?? is it: $limit = $time - 1209600 (84600 * 14). query = "select * from table where time > limit"; or something??? any help would be nice! Thanks!!! Sandeep __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net