Re: paging at which level

On Sat, 2008-10-18 at 12:54 +0200, Alain Roger wrote: > Hi, > > i would like to know what is the best approach for paging ? > usually i use PEAR and page thanks their table library, but to avoid high > transfer of data from DB to PHP page it is better to do the paging at > database level. If you want top page data then you absolutely should NOT retrieve the entire set of results (unless they are less than your paging length). > I would like to know what is your point of view on this topic and what do > you use to do ? Use a paging system that takes a query or can build the query itself. Most decent libraries or frameworks have something already built to do so. Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP