RE: MS SQL Query question

["Derrick Hermanson" <dhermanson@xxxxxxxxx>]

try something like this

$result = mssql_query ($query);
if ($result) {
	while ($template_args = msssql_fetch_array ($res)) {
		//what ever you want to do with the data
	}
}

Derrick Hermanson
Programmer/Analyst I
Acton International LTD.
402.470.5816
mailto:dhermanson@xxxxxxxxx


-----Original Message-----
From: Ron.Herhuth@xxxxxxxxxxxxxxxxx
[mailto:Ron.Herhuth@xxxxxxxxxxxxxxxxx]
Sent: Tuesday, May 25, 2004 1:30 PM
To: php-windows@xxxxxxxxxxxxx
Subject:  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