Reorder MySQL Results.

From: MS (SpamNoThnx_santa____clause_at_hotmail.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 14:44:54 +0000 (UTC)

after...

$start = 0;
$result = mysql_query("SELECT * FROM dbname.tbl_table
       WHERE ID = '$id'
       ORDER BY Time DESC
       LIMIT $start,21");

This extracts the 21 records I want, which are the 21 most recent records.
But I would like to read these records in the ...

$row = mysql_fetch_assoc($result);

statement in reverse order to what the result set is in. i.e. the oldest
record first.

I am sure there are many ways to accomplish this but I am just wondering
which would be best and quickest.

thnx
Alex 

-- 
----------------------------------------------------------------------------
http://www.clickonlingerie.com?SIG - Exotic Erotic Lingerie
----------------------------------------------------------------------------