|   | php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
| 
 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits              [2001-01-12 16:06 UTC] cynic@php.net
  [2001-06-30 15:48 UTC] fmk@php.net
 | |||||||||||||||||||||||||||
|  Copyright © 2001-2025 The PHP Group All rights reserved. | Last updated: Fri Oct 31 03:00:01 2025 UTC | 
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); ?>