Re: LIMIT() function example

Simply keep track of where you are in the returned results. Then do something like: SELECT * FROM table WHERE condition LIMIT $start,$nbrrecs Increment $start by $nbrrecs with each call for a new page ---- Original Message ----- From: "Francisco Vaucher" <fvaucher@tycoint.com> To: "PHP List (E-mail)" <php-general@lists.php.net> Sent: Thursday, October 17, 2002 1:04 PM Subject: [PHP] LIMIT() function example Hi to all, Can anybody give me an example on how to use the limit() function of MySQL to build a paging script with PHP ? If anybody have an example It would be great! Thanks a lot! Francisco -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php