Re: Display Records in Multiple Pages help please !

If you're using CGI/Perl, WHY WHY WHY are you asking questions on a PHP list? 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:justin@indent.com.au] 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