Displaying news across several pages

[Pag]

Hi,

I am a beginner in this MySQL thing, and i am trying to figure out how i can split, for example, some news articles i already have in a table, into several pages.

On the site i am building, i get the 10 first news and display them. I use "SELECT FROM NEWS ... ORDER BY DATE DESC LIMIT 10". Is there any mysql command to select the next 10 items, for example? something like "LIMIT from 10 to 20" hehe, i know it sounds weird. :-)

Thanks.

Pag



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php