question about looping with databases

[Anon]

$result = mysql_query("SELECT * FROM devjournal",$db);

while ($myrow = mysql_fetch_array($result)) {

  printf("<a href=\"%s?id=%s\">%s, %s/%s/%s</a> \n", $PHP_SELF, $myrow["id"], $myrow["subject"], $myrow["month"], $myrow["day"], $myrow["year"]);

  printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF, $myrow["id"]);

thats the coe i am using. it works perfectly fine but its backwards. what i mean is it comes out like this

Test 9/15/01
2ndtest 9/16/01

i want it to come out with the new dates on top. if anyone knows what condition to put in the while loop i would appreciate it. Im new to PHP but have used ASP before.

[Anon]

get the number of rows and step backwards through the array using a for next loop instead of a while loop.

there may be other ways, you can check the manual. php.net

[miyake]

If you date is stored as YYYY-MM-DD, then this will work perfectly...just a suggestion.

SELECT * FROM devjournal ORDER BY date DESC

That'll show the newest to the oldest.