CodingForums.com - View Single Post - How to Display the latest 8 stories' title

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

09-07-2012, 07:54 AM	PM User \| #2
webmiral New Coder Join Date: Sep 2012 Posts: 12 Thanks: 0 Thanked 2 Times in 2 Posts	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