| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|Query database to output rows 11-20, not 1-10|
Beyond Order By
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");
However, on a second page, I would like to list articles 11-20 instead of 1-10. How can I do this?
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
Thank you very much, it works great!
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved