wtfsmd Posted July 25, 2007 Share Posted July 25, 2007 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. Link to comment https://forums.phpfreaks.com/topic/61675-solved-displaying-mysql-results-in-while-loop/ Share on other sites More sharing options...
wtfsmd Posted July 25, 2007 Author Share Posted July 25, 2007 solved $result = mysql_query("SELECT * FROM news ORDER BY id DESC") Link to comment https://forums.phpfreaks.com/topic/61675-solved-displaying-mysql-results-in-while-loop/#findComment-306996 Share on other sites More sharing options...
simcoweb Posted July 25, 2007 Share Posted July 25, 2007 Do you have a date or time stamp entered for the articles? You could make it order by the date if you do. Link to comment https://forums.phpfreaks.com/topic/61675-solved-displaying-mysql-results-in-while-loop/#findComment-306999 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.