when 2 arguments are specified for LIMIT then the first argument is the offset and the second is the max number of rows e.g. below
select * from mytable limit 10,10 select * from mytable limit 20,10 Rich -----Original Message----- From: Pag [mailto:[EMAIL PROTECTED]] Sent: 25 January 2003 05:10 To: Roger Davis; [EMAIL PROTECTED] Subject: Displaying news across several pages 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
