Need to Flag NEW listings

[Anon]

Greetings,

I have a mysql date field named 'dt_created'

I want to do an if/else conditional (in my while clause) that simply sez...

If Today MINUS dt_created is <7
then 'do this'
If not 'do this'

Something like...

if ($dt_created <= 7 days)
{$flag = "new this week";}
else {$flag = "old listing" ;}

HOW DO I subtract Today from this date field?

[Anon]

Here's what you can do, provided that your date information is stored as a temporal data type in your MySQL table:

First, get the current UNIX timestamp, using the time() function:
$now = time();

When pulling the data from the database, MySQL provides a function called UNIX_TIMSTAMP(), which will convert any temporal data type to a UNIX timestamp. That oughtta take care of retrieving the temporal data in a fashion that can be dealt with by PHP... So your query would be something like:
"SELECT UNIX_TIMESTAMP(dt_created) FROM table WHERE yada yada yada..."

Since UNIX time is measured in seconds since Jan 1, 1970, and we know that there are exactly 86,400 seconds in a day, you could try something like:

if($mysql_dt_created < ($now = (86400 * 7))) {
// more than a week old code goes here
} else {
// less than a week old code goes here
}

Should work...