mysql ordering outpts , reversed

[Chadian22]

So i finally got my script to read my database.

mysql_select_db("blog");
$result = mysql_query("select * from blog");
while ($row = mysql_fetch_array($result)) {
echo(" <div class=\"title\">".$row['Title']."</div>"."<div class=\"blubber\"><div class=\"time\">Posted on ".$row['Date']." ".$row['Time']."</div>" . $row['Text']. "</div><br />");
}

So it orders it out all nicly, but if i keep going it'll post my very first posts first, when i want it to go opposite, so the most recent is on top. So how would I do this, i have an integer id value which is assigned to each post and im planning on using this to arrange the information

[nemonoman]

SELECT *
FROM blog
ORDER BY id
DESC

RTFM.

[Chadian22]

thanks man. I was having some search results from the forum that werent really describing what i was looking, and i wanted something a bit more specific because I can easily screw up code when trying to blend 2 examples , but thanks you fixed it perfectly .