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

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)

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)

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)

Thank you very much, it works great!