Re: db paging with MS Sql

AFAIK this is more of a SQL thing than a DB specific thing. Just look up the LIMIT equivilent in MS SQL (should just be LIMIT) and use that for paging, once you get the hang of it it's quite easy. You can look through my paging class at www.miester.org/software - it goes one deeper and does [ prev ] [1] [2] [3] [ next ] and then only shows X ammount of pages so when you get to page 10 it would show [9] [10] [11] Hope that helps. --Joe On Sun, Feb 04, 2001 at 10:02:06PM -0300, Manuel Lemos wrote: > 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 > -- > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- ------------------------------------------------------------------------------- Joe Stump, PHP Hacker, joestump98@yahoo.com -o) http://www.miester.org http://www.care2.com /\\ "It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V -------------------------------------------------------------------------------