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/