array + mysql question

[Tommy101]

I have made a script that gets information from a mysql table and shows it in a html table. However i would like to have the html show the information from the bottom up. (because when i add a row in my mysql table it ends up at the bottom).

Is there any way one could use the SORT_DESC function?

My code looks like this at the moment:

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td>$col_value</td>\n";
   } 

[lintz]

If you have an ID field in your table you could sort by that so the newest records are always at the top. HTH

$SQL = "SELECT * FROM YourTable ORDER BY ID DESC";