sort a list from highest to lowest

i have a script that posts the id's onto a page, the only problem is that it posts the highest id number last.

i would like it to post the highest id number first and the lowest last

heres my script

<th><font face="Ar开发者_如何学Pythonial, Helvetica, sans-serif">id</font></th> 

$f1=mysql_result($result,$i,"id");

<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>

this code above does a great job of getting the id from my mysql db

if this makes no sense please tell me and ill try to explain is in another way

---

Put this at the end of your query

Order by Id Desc

---

SELECT * FROM table WHERE 1 ORDER BY id DESC

---

That should be done in your SQL query.

Example:

SELECT * FROM table ORDER BY id DESC;

The ORDER BY clause will do perfectly.