On 13 Jun 2002, at 21:36, Peter Romianowski wrote: > 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 [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- 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