Re: db paging with MS Sql
| From: | Alain Fontaine | Date: | Sun, 04 Feb 2001 18:18:03 +0000 |
| Subject: | Re: db paging with MS Sql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-38123@lists.php.net to get a copy of this message | ||
Scott,
As far as I know, MS SQL supports a syntax like this:
SELECT TOP 10 FROM table_name WHERE etc etc
However, I don't know how to make it start from a certain offset; I guess MS
SQL's documentation, especially the T-SQL doc, should help.
""Scott Parks"" <sparks@magpage.com> a écrit dans le message news:
00b601c08ed1$ef153f30$0f00a8c0@SPARKS99...
> 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.
>
> tia
>
>
> --
> 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
>