Welcome to WebmasterWorld Guest from 54.147.158.215

Forum Moderators: open

Message Too Old, No Replies

Query database to output rows 11-20, not 1-10

Beyond Order By

     
3:37 pm on Feb 28, 2008 (gmt 0)

Junior Member

5+ Year Member

joined:Dec 5, 2007
posts:107
votes: 0


I'm using PHP to access a MySQL table containing multiple articles with different published dates.

I would like to query this database for output, and have the most recent article on top.

mysql_query("SELECT * FROM articles ORDER BY published DESC LIMIT 10");

Works great.

However, on a second page, I would like to list articles 11-20 instead of 1-10. How can I do this?

7:23 pm on Feb 28, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:May 6, 2005
posts:863
votes: 0


try 11, 10 in place of the 10 it will grab result 11 and the next 10 results

mysql_query("SELECT * FROM articles ORDER BY published DESC LIMIT 11, 10");

It would be better to do some proper pagination that extra pages are created on the fly, thats if you result set is going to keep growing. Saves headaches later

2:29 am on Mar 2, 2008 (gmt 0)

Junior Member

5+ Year Member

joined:Dec 5, 2007
posts:107
votes: 0


Thank you very much, it works great!
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members