homepage Welcome to WebmasterWorld Guest from 184.73.87.85
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Query database to output rows 11-20, not 1-10
Beyond Order By
itledi




msg:3587164
 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




msg:3587395
 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




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

Thank you very much, it works great!

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved