PHP 4.0 Bug #9497: closed mysql connection after calling a function that uses another mysql conn.

From: coberau@gmx.net Operating system: SuSE Linux 7.0 PHP version: 4.0.4 PHP Bug Type: MySQL related Bug description: closed mysql connection after calling a function that uses another mysql conn. in file functions.inc: function func1($blabla) { $conn = mysql_connect ("host","user","pass"); mysql_select_db("db",$conn); $resset=mysql_query("SELECT a,b,c FROM ATable",$conn); mysql_close($conn); } ------------------- file index.php: include ("functions.inc"); $conn_main = mysql_connect ("host","user","pass"); mysql_select_db("db",$conn_main); $resset=mysql_query("SELECT a,b,c FROM ATable",$conn_main); <-- this statement works and returns a result func1($abc); <-- call defined function $resset=mysql_query("SELECT a,b,c FROM ATable",$conn_main); <-- after calling the above defined function i get an error: warning: 1 is not a valid mysql link resource mysql_close($conn_main); so thats the problem: i have a script that makes a mysql connection. i can select, update, insert aso. from the db. then i call a function that itself makes a connection to the same db, does something with it (works fine) closes the connection and returns. i dont use global or give the main connection as an argument, its just a plain standalone function. after calling the function the main script has lost its mysql connection (its no timeout since the function doesnt take long to execute). the same scripts work with PHP version 4.0.1pl2. both pcs have the same setup (apache 1.3.12, mysql 3.22.32, the rest as rpms from the distibution cds). its all the same except the php-version (both compiled with the standard options --with-apxs --with-mysql -> make -> make install) -- Edit Bug report at: http://bugs.php.net/?id=9497&edit=1