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/?[EMAIL PROTECTED]
> --
> E-mail: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
-------------------------------------------------------------------------------
Joe Stump, PHP Hacker, [EMAIL PROTECTED] -o)
http://www.miester.org http://www.care2.com /\\
"It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V
-------------------------------------------------------------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
