Re: Fetching PEAR DB in a set

Hi Sanjay. Have you looked at DB_common::limitQuery()? That may help. Perhaps you can then save the key of the last row, and include it in the query for the next page, to then fetch rows only after that. (thats assuming the data is sorted by a key, of course!) Hope thats helpful, Peter Sanjay wrote: > > How do I fetch say 20 records at a time. I am using Oracle database. Suppose my query returns > 1000 records but I want to fetch 20 records at on time and then display these 20 records on your > page and then you keep fetching next 20 records and so on.. How should I do it in PEAR DB. > > Thanks > Sanjay