#30592 [Opn->Bgs]: not a valid MySQL-Link resource

ID: 30592 Updated by: georg@php.net Reported By: v_shiray at ukr dot net -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Linux PHP Version: 4.3.9 New Comment: Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php See http://www.php.net/mysql_connect Previous Comments: ------------------------------------------------------------------------ [2004-10-28 03:01:18] v_shiray at ukr dot net MySQL 4.0.20 Problem has been detected also with PHP 4.3.8 and 5.0.2 on the same computer RedHat 9.0, MySQL 3.23.58, PHP 4.3.9 ------------------------------------------------------------------------ [2004-10-28 01:52:39] v_shiray at ukr dot net Description: ------------ Below code has produced next output: Current connections: Resource id #4, Resource id #4 PHP Warning: mysql_query(): 4 is not a valid MySQL-Link resource in ... Tested on Linux Slackware 10.0 PHP Version => 4.3.9 System => Linux gate 2.4.27-lck3 #3 ðÔÎ á×Ç 13 01:00:30 EEST 2004 i686 Build Date => Sep 30 2004 23:01:51 Configure Command => './configure' '--prefix=/opt/php' '--with-config-file-path=/opt/php/etc' '--disable-cgi' '--enable-static' '--disable-shared' '--enable-sockets' '--enable-ftp' '--with-mysql=/usr' '--with-zlib=/usr' PS. PHP 4.3.6 and 4.3.7 are not affected for this problem. Reproduce code: --------------- error_reporting(E_ALL); $db1 = mysql_connect ('localhost', 'test', '1'); $db2 = mysql_connect ('localhost', 'test', '1'); echo "Current connections: $db1, $db2\n"; mysql_close($db2); $db2 = 0; mysql_query('SELECT 1+1', $db1); Expected result: ---------------- Resource ID must be available with $db1 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30592&edit=1