Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: open
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?
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