"LIMIT" problem MSSQL
| From: | Noam Giladi | Date: | Wed, 19 Feb 2003 14:59:51 +0000 |
| Subject: | "LIMIT" problem MSSQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25762@lists.php.net to get a copy of this message | ||
I'm trying to split results into different pages and number the pages
accordingly. I've been able to build a fairly intelligent page numbering
system which knows which rows it should pull (at least by numbering each row
numerically) but I don't know how to construct a SQL query to pull 10
results starting at a certain number.
please did anyone wrote a proc that do it?.