AW: [PHP-WIN] MS SQL Query question
| From: | Dr. Robert Probst | Date: | Tue, 25 May 2004 10:52:06 +0000 |
| Subject: | AW: [PHP-WIN] MS SQL Query question | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-23836@lists.php.net to get a copy of this message | ||
IN MY (not MS) SQL I would try
mysql_data_seek ($result, 0);
to move the internal pointer to the first data row
I dont know at the moment if there is a similar function in the msxxxx area.
maybe it helps
robert
> -----Ursprüngliche Nachricht-----
> Von: Ron.Herhuth@tatumpartners.com
> [mailto:Ron.Herhuth@tatumpartners.com]
> Gesendet: Dienstag, 25. Mai 2004 20:30
> An: php-windows@lists.php.net
> Betreff: [PHP-WIN] MS SQL Query question
>
>
>
> When I run a query the syntax looks like this:
>
> $result = mssql_query($query);
> $numRows = mssql_num_rows($result);
>
> for($i=0; $i<$numRows; $i++)
> {
> $row = mssql_fetch_array($result);
> }
>
> but if I go to try and loop through the resultset again it
> wont work unless I run this line again "$result =
> mssql_query($query);"
>
> I'm sure this is wasting resources but I can't seem to get
> around it. Any suggestions?
>
> Thanks,
> Ron
>
>
>
>
>
>