[Resolved] sql SELECT query :)

[helz]

im creating multipage code to add to ma news/guestbook section so that if there are more than 5 rows a link is displayed to show the next ones from the db.
only thing i need help with is the sql query. easy enough to get the latest 5 from the db using:
LIMIT 5 ORDER BY id DESC
that shows 1-5 but how do i get it to show 6-10?

ty for help

[TheIceman5]

limit 6,10 i believe

[helz]

thanks a bundle, will try it when i get to it

[helz]

i found out that the LIMIT #,# is actually:
the first number is where it starts and the second number is how long it lasts for, so:
5,6 starts to display row 5 and lasts for 6 so it displays:

row 5
row 6
row 7
row 8
row 9
row 10