Thanks. I wasnt sure what those params woudl be. Thanks -TJ
On May 25, 5:09 am, Tony <[EMAIL PROTECTED]> wrote: > Hi Tom, > > You must calculate this values by hand. > I personaly use a exelent adodb library which returns this values from > the resulting query. > > In your case: > To the server are passed 4 parameters, that you must have attention. > page - the requested page > rows - the number of rows, that the server must return > sidx - the culumn that must be sorted > sord - the sort order > > Having this you must first calculate haw many rows are returned from > the query - i.e use a count(*) function - let this is variable > $mycount > The total number of pages is (fill total tag with this value) : > $mycount/rows - (round this value). > If the query return data you must fill the tag page with the requested > page parameter. > > As for the LIMIT in MySql - this can be calculated easy > You reqest by example page 5, then > you request must end with 5*rows > The begining records are rows*(5-1) + 1 records or 4*rows + 1 > > By the way I have add some additinal features - subgrid. Have fixed > some bugs. > This will be available next week > > Regards > Tony