Re: db paging with MS Sql

Hello Joe, On 04-Feb-01 21:18:55, you wrote: >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] I suppose you mean MySQL and not MS (MicroSoft) SQL . They are not compatible. 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 --