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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Wed May 01 21:01:29 2024 UTC