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
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
43 - 10 = ?
Subscribe to this entry?

 
 [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: Thu Mar 28 19:01:29 2024 UTC