How to Display the latest 8 stories' title

Thuita Maina · 09-07-2012, 07:32 AM

I have created a sidebar that is supposed to show the titles of the latest 8 stories. I however have the premonition that the sidebar will only display the titles of rows 0 to 8 instead of displaying the last eight regardless of row number. Below is the php code that I wrote for displaying the titles with the code in red triggering my premonition. Will the LIMIT statement really work to achieve my objective?

Code:

<?php 
 
// Include database connection settings
include('config.inc');
  
$result = mysql_query("SELECT * FROM stories order by datetime ASC limit 0,8");    
  
while($row = mysql_fetch_assoc($result))  
          {                 
               $id=$row['id']; 
               echo '<h3><a href="stories.php?id='.$id.'">' .$row['title'] . '</a></h3>';
               echo 'By ' . $row['names'] . '';
                 
          }  
     
  ?>

Again I ask, will the limit statement only select the last eight or the rows 0 to 8?

webmiral · 09-07-2012, 07:54 AM

Hi,

The first 8 story:

Code:

SELECT * FROM stories order by datetime ASC limit 0,8

The last 8 story:

Code:

SELECT * FROM stories order by datetime DESC limit 0,8

Thuita Maina · 09-07-2012, 08:05 AM

Thanks Webmiral.

vroom · 09-07-2012, 02:09 PM

It's common just to use "limit 8" if you don't need a range such as "limit 2,10".