Re: db paging with MS Sql

Hello Scott, On 04-Feb-01 14:41:58, you wrote: >Has anyone seen a good lession or code example on paging records from MS Sql >7? Say I have 300 records and >want to break them down to 10 per page using [previous | next ] and a list >of page numbers at the bottom. You may want to use Metabase that lets you pick the range of rows that are returned by a SELECT query. It works not only with Microsoft SQL server but also many other databases supported by PHP. http://phpclasses.UpperDesign.com/browse.html/package/20 You may also want to try this query result table display class that displays select query result rows in HTML tables and may generate automatically links to move go to the Previous, Next, First, Last or any other page of query results. http://phpclasses.UpperDesign.com/browse.html/package/130 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --