From:             [EMAIL PROTECTED]
Operating system: WIN NT
PHP version:      4.0.4
PHP Bug Type:     *General Issues
Bug description:  mssql fetch array bug

If you run mssql_fetch_array on the same table more than once the script will never 
finish.
If you use mssql_fetch_row is works fine. 

<?
$sql1 = "select price from vw_items where item like '30482-__' order by item"; 
$result1 = mssql_query($sql1); 
while ($row1 = mssql_fetch_array($result1)) { 
  $price = $row1["price"]; 
  echo "$$price"; 
} 
mssql_free_result($result1); 
Echo "NEW ONE"; 
$sql2 = "select price from vw_items where item like '30403-__' order by item"; 
$result2 = mssql_query($sql2); 
while ($row2 = mssql_fetch_array($result2)) { 
  $price = $row2["price"]; 
  echo "$$price"; 
} 
mssql_free_result($result2); 
?>



-- 
Edit Bug report at: http://bugs.php.net/?id=8642&edit=1



-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to