> > > SELECT * FROM myproducts ORDER BY sales LIMIT 11,10 > > > > will show place 11 to 20 > > Actually you want "LIMIT 10,10" for places 11 to 20, at least the way > most people count places. The LIMIT offset starts numbering the > records at 0, not 1. > > http://www.mysql.com/doc/S/E/SELECT.html >
Ehm, oops - of course! Peter --------------------------------------------------------------------- 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