I've given you a hint, so perhaps take that hint and ask a question on an Oracle list, or search the Oracle documentation for similar functions.
Justin French
On Tuesday, August 5, 2003, at 10:37 PM, Coello, David wrote:
thank you for replying, good morning. im using oracle 8. with cgi/perl thank you david
-----Original Message----- From: Justin French [mailto:[EMAIL PROTECTED]
Well, you haven't told us what database you're using at all, but I'll assume MySQL. In which case you should look at the LIMIT part of your query.
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)
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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
