Pag, as Rich said:
> select * from mytable limit 10,10 > select * from mytable limit 20,10 In your PHP (?) application, you would have this like: select * from mytable limit $start,$range You could set up range (e.g. in config.inc.php) to whatever you want for the site, and you would add $range to $start when the user clicks on "next", and substract $range from $start when the user clicks on "previous". HTH, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Rich Gray" <[EMAIL PROTECTED]> To: "Pag" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 25, 2003 12:03 PM Subject: RE: Displaying news across several pages > 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 > --------------------------------------------------------------------- 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