row and date

[NZ_Kiwis]

each row in my databas has a date column if the date is prior to today i want it to show as out of date if i don't have values in other columns.

how can you do that?

[Krik]

$row = mysql_fetch_array($results)
$outofdate = (strtotime($row['date']) < strtotime(date('Y-m-d'))) ? 'Out of Date' : $row['date'];

Of course your date column needs to be in some kind of a standard formatting.

Of course if you were storing the date as a time stamp it would get even easier.

[bradgrafelman]

SELECT IF(dateCol < CURDATE(), 'Out of Date', 'Current') AS dateStatus ...