http://www.mysql.com/doc/en/SELECT.html
All you need to do is pass around a starting point variable on each page, so that you know where the result for the next page of results will start from (eg row 40 or 41 for page 3)
Justin
On Tuesday, August 5, 2003, at 02:53 AM, Coello, David wrote:
good afternoon i found a forum about displaying 25 records per page, im using cgi and i need also to display only 25 records per page but i want to be able to go to my next page and see the next 25 and so on... the proble that im having is that i have a about 2000 records and the query that i use calls all of them? how do i limit them
thank you david coello
David Coello [EMAIL PROTECTED] phone: 212-657-1649 Fax: 212-657-7517
--- [This E-mail scanned for viruses]
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
