Record Page Through sqlServer Woes
| From: | Lerp | Date: | Wed, 09 Jan 2002 17:41:00 +0000 |
| Subject: | Record Page Through sqlServer Woes | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15587@lists.php.net to get a copy of this message | ||
Hi all, I have a small php app where I'd like to incorporate page throughs
of records, say 10 at a time.
I'm using sqlServer and have run into a problem using the LIMIT statement
within my query.
Code:
$sqls = "SELECT consultantid, firstname, lastname, city, country, category,
yearsexp FROM CONSULTANT ORDER BY consultantid DESC LIMIT $var1, $var2" ;
So how the heck do I get around this problem since I've discovered that the
LIMIT statement will not work with sqlServer??? :)
Thx a bunch :) Joe