RE: [PHP-DB] "LIMIT" problem MSSQL
| From: | Snijders, Mark | Date: | Wed, 19 Feb 2003 15:01:23 +0000 |
| Subject: | RE: [PHP-DB] "LIMIT" problem MSSQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25763@lists.php.net to get a copy of this message | ||
$start = 10;
$numbers_to_show = 25;
$sql = "SELECT * FROM bla Limit $start, $numbers_to_show";
or just go to mysql.com and use the manual :)
-----Original Message-----
From: Noam Giladi [mailto:noam@i-com-it.com]
Sent: woensdag 19 februari 2003 16:00
To: php-db@lists.php.net
Subject: [PHP-DB] "LIMIT" problem MSSQL
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?.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php