Re: AW: [PHP-WIN] MS SQL Query question

http://nl3.php.net/manual/en/function.mssql-data-seek.php On Tue, 2004-05-25 at 12:52, Dr. Robert Probst wrote: > 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 > > > > > > > > > > > >