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@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
