Welcome to WebmasterWorld Guest from 54.226.147.190

Forum Moderators: open

Message Too Old, No Replies

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

Beyond Order By

     

itledi

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

5+ Year Member



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?

wheelie34

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

WebmasterWorld Senior Member 10+ Year Member



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

itledi

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

5+ Year Member



Thank you very much, it works great!
 

Featured Threads

Hot Threads This Week

Hot Threads This Month