[SOLVED] Displaying MySQL results in while loop

[wtfsmd]

all of my code works i just had a simple question, when my news is displayed its like this

 

1 = first topic ever made 2 = next ect..

 

 

1

2

3

4

 

i want the newest topic posted to show up on top like this

 

4

3

2

1

 

$result = mysql_query("SELECT * FROM news LIMIT 0,10")
or die(mysql_error());  

							// store the record of the "example" table into $row
							while($row = mysql_fetch_array($result)){
							// Print out the contents of the entry
					?><b>
                        	<?php echo $row['title'];?>
                        </b><br />By <?php echo $row['author'];?><br />Published:  <?php echo $row['date'];?><br /><p> </p><p align="center"></p><?php echo $row['body'];?><br /><br /><br /><hr><?php }?>
                        

 

 

if this didn't make any sense please tell me, lol.

[wtfsmd]

solved

 

$result = mysql_query("SELECT * FROM news ORDER BY id DESC")

[simcoweb]

Do you have a date or time stamp entered for the articles? You could make it order by the date if you do.