Jump to content

[SOLVED] Displaying MySQL results in while loop


wtfsmd

Recommended Posts

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.