RE: [PHP] mssql_data_seek offset error
| From: | Jay Blanchard | Date: | Tue, 09 Mar 2004 21:45:23 +0000 |
| Subject: | RE: [PHP] mssql_data_seek offset error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-179937@lists.php.net to get a copy of this message | ||
[snip]
> Try this ....
>
> $query = "SELECT DISTINCT q.questions
> FROM SG_Questions as q, SG_QuesRef as r
> WHERE r.pos_id = '$pos' AND r.sic_id = '$sic' AND
> r.cat_id
> = '$cat' AND r.ques_id = q.ques_id";
> $result = mssql_query($query) or die("Can not execute query $query.
");
>
> $i =1;
>
> for ($i = $paging; $i < $paging + $limit; $i++){
> $cnt = mssql_data_seek($result, $i);
> $row = mssql_fetch_array($result);
> }
That cured 9 but it still freaks on 10. It returns the error for the
entire
loop count.
[/snip]
Becaue $paging might be turning the integer you need into text? Maybe?