ID: 8642 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.4 Assigned To: Comments: This error can not be reproduces with php 4.0.6. PLease update to the latest version. Previous Comments: --------------------------------------------------------------------------- [2001-01-12 16:06:25] [EMAIL PROTECTED] reclassifying --------------------------------------------------------------------------- [2001-01-10 16:12:26] [EMAIL PROTECTED] 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); ?> --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=8642&edit=2 -- 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]