Bug #16295 Updated: # is not a valid resource

ID: 16295 Updated by: joyeux@1984.cz Reported By: joyeux@1984.cz Status: Open Bug Type: MySQL related Operating System: MDK 8.2 PHP Version: 4.1.2 New Comment: This SOMETIMES produces an error "3 is not a valid mysql resource on line 2" (or other error numbers) First fetch_array is usually good. It looks like php forget a resource link when calling other query (line 3). 1| $sql=mysql_query("SELECT id FROM tbl"); 2| while($row = mysql_fetch_array($sql, MYSQL_ASSOC)) { 3| mysql_unbuffered_query("DELETE FROM tbl2 WHERE id=".$row["id"]); 5| } When I first fetch all data to an array and then use them by the same way, it works. 1| $ARR=array(); 2| $sql=mysql_query("SELECT id FROM tbl"); 3| while($row=mysql_fetch_array($sql, MYSQL_ASSOC)) $ARR[]=$row; 4| foreach($ARR as $row) mysql_unbuffered_query("DELETE FROM tbl2 WHERE id=".$row["id"]); I can't find where is the problem. I try to put some sleep() after queries but nothing happens. Previous Comments: ------------------------------------------------------------------------ [2002-03-26 18:38:18] joyeux@1984.cz This SOMETIMES produces the error "3 is not a valid mysql resource on line 2" (or other numbers) First fetch_array is usually good. It looks like php forgot a resource link when calling other query. 1| $sql=mysql_query("SELECT id FROM tbl"); 2| while($row = mysql_fetch_array($sql, MYSQL_ASSOC)) { 3| mysql_unbuffered_query("DELETE FROM tbl2 WHERE 4| id=".$row["id"]); 5| } When I use an array to store data from tbl1 instead direct fetching, it works. 1| $ARR=array(); 2| $sql=mysql_query("SELECT id FROM tbl"); 3| while($row=mysql_fetch_array($sql, MYSQL_ASSOC)) $ARR[]=$row; 4| foreach($ARR as $row) mysql_unbuffered_query("DELETE FROM tbl2 WHERE id=".$row["id"]); I can't find where is the problem. I try to put some sleep() after mysql_query but it's the same. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16295&edit=1