This depends entirely on the format which the date is stored.
if its stored in date soemthing like
Code:
WHERE date > 2008-01-01 AND date < 2008-12-31
would select all dates from this year.
then
PHP Code:
while(row fetch... ) { echo date('Y-m-d') - $row['date']; }
would create a list of all the dates from this year, minus todays date.
TP apprieciated
Dan
__________________
Discounted Web Hosting With XDnet! >> Get 25% of hosting~ Promo: Webmaster-talk <<
|