Welcome to WebmasterWorld Guest from 18.204.2.53

Forum Moderators: open

Message Too Old, No Replies

limit records?

     
12:48 pm on Jun 29, 2007 (gmt 0)

New User

10+ Year Member

joined:June 28, 2007
posts:11
votes: 0


if i had 50 records in a database, how would i return 5 records ordered by date, but not actually display the first record?
thanks
2:59 pm on June 29, 2007 (gmt 0)

New User

10+ Year Member

joined:Feb 2, 2005
posts:34
votes: 0



SELECT * FROM table ORDER BY date_column LIMIT 1,4
5:12 pm on June 29, 2007 (gmt 0)

New User

10+ Year Member

joined:June 28, 2007
posts:11
votes: 0


thank you.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members