[RESOLVED] reversing display of for loop

[knucklehead]

hello, i have a simple script here;

$selekt = mysql_query("SELECT * FROM `my_table` ORDER BY date DESC") or die(mysql_error());
$numrows = mysql_num_rows($selekt);
$i = 0;
for ($i; $i <= $numrows; $i++) {

while ($row = mysql_fetch_array($selekt)) {

	$new_date=Date('d.m.Y', strtotime("1.1.2009. +".$i." days"));

	echo "<p><b>".$new_date."</b><br />".$row['column']."</p>";

	$i++;

}
}

and it displays this:

01.01.2009.
text

02.01.2009.
text

03.01.2009.
text

etc.

i wonder how to make it display dates in 'reverse' order? like this:

03.01.2009.
text

02.01.2009.
text

01.01.2009.
text

etc.

the dates are generated to start from january 1st 2009, they are not from table!

thanks!

[knucklehead]

lol
seems that i figured it out myself =)

i added another variable

$last_date = Date('d.m.Y.', strtotime("31.12.2008. +".$numrows." days"));

and then generated dates in my loop like this;

$new_date=Date('d.m.Y', strtotime($last_date." -".$i." days"));

done. =)