php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #8642 mssql fetch array bug
Submitted: 2001-01-10 16:12 UTC Modified: 2001-06-30 15:48 UTC
From: wayne at whatazoo dot com Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.0.4 OS: WIN NT
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: wayne at whatazoo dot com
New email:
PHP Version: OS:

 

 [2001-01-10 16:12 UTC] wayne at whatazoo dot com
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); 
?>

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-12 16:06 UTC] cynic@php.net
reclassifying
 [2001-06-30 15:48 UTC] fmk@php.net
This error can not be reproduces with php 4.0.6. PLease update to the latest version.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Wed Feb 05 17:01:30 2025 UTC