Move to first record mssql
| From: | Louis Young | Date: | Thu, 20 Jan 2005 07:32:29 +0000 |
| Subject: | Move to first record mssql | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-25407@lists.php.net to get a copy of this message | ||
Hi there
I'm looping through an mssql dataset, using while($row=mssql_fetch_array($rsElecTrans)), but now I would like to loop through the same dataset again later on, but inn order to do this I need to move to the first record, so I tried:
mssql_data_seek($rsElecTrans, 0);
while($row=mssql_fetch_array($rsElecTrans)) // this is line 514
But I get the following error:
*Warning*: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in *C:\Program Files\Apache Group\Apache2\htdocs\spar\admin\rpt_electrans.php* on line *514
How does that work?
Cheers
Louis
*