Yes but is that "limit number_to_return, offset " a standard SQL clause ?
Erik Tank wrote: > 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 >>******************************************************************* >> >> >> >> > > -- ******************************************************************* Eddie IANNUCCELLI - tel: 05 61 28 54 44 INRA, Laboratoire de G�n�tique Cellulaire Chemin de Borde Rouge - Auzeville -BP27 31326 Castanet Tolosan *******************************************************************
