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@xxxxxxxxxxxxxxxxx > [mailto:Ron.Herhuth@xxxxxxxxxxxxxxxxx] > Gesendet: Dienstag, 25. Mai 2004 20:30 > An: php-windows@xxxxxxxxxxxxx > Betreff: 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 > > > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
