The way that I have been tackling this problem is that I create a "navigation bar" (looks like this: <<Prev 1 2 3 4 Next>>). Each number is a link to the same script and each link specifies a start position or offset. If this start number is passed into the script I add "limit number_to_return, offset" to the select statement. This way only that subset of the data is return. Walla!?
Hope that helps, Erik Tank Bowne of Phoenix Internet Services 602-817-4705 On Tue, 19 Mar 2002 12:21:04 +0100 eddie iannuccelli <[EMAIL PROTECTED]> wrote: > hi, > > I'am currently using fetchrow_hashref(because of it friendly field name > access oriented syntax) in a loop to get and display data in a html page > , but as data grows I need now to paginate resultset. > > Since the user can change the sort order, I can't use DB counter ID, so > how can I do ? > > In other words, how to paginate big amount of data intelligently with > fetchrow_hashref (for use with CGI) ? > > Thanks > -- > ******************************************************************* > Eddie IANNUCCELLI - tel: 05 61 28 54 44 > INRA, Laboratoire de G�n�tique Cellulaire > Chemin de Borde Rouge - Auzeville -BP27 > 31326 Castanet Tolosan > ******************************************************************* > > >
