PHP 4.0 Bug #5986: Combination of msql() and msql_connect() causes lost connections.

From: pete@byways.org Operating system: RedHat Linux 6.2 PHP version: 4.0.1 PHP Bug Type: mSQL related Bug description: Combination of msql() and msql_connect() causes lost connections. The following script causes unexpected errors: Function test () { $conn1 = msql_connect(); msql_select_db("nsbo", $conn1); $Res = msql_query("SELECT * FROM State", $conn1); echo msql_NumRows($Res)." rows in State<br>"; msql_close($conn1); } test(); $Res = msql("nsbo", "SELECT * FROM Member"); echo msql_NumRows($Res)." rows in Member<br>"; $Res = msql("library", "SELECT * FROM Publication"); echo msql_NumRows($Res)." rows in Publication<br>"; The output from PHP is this: 60 rows in State 713 rows in Member Warning: 1 is not a valid mSQL-Link resource in /disk2/websites/NSBO/test/test_db.html on line 18 Warning: Supplied argument is not a valid mSQL result resource in /disk2/websites/NSBO/test/test_db.html on line 19 rows in Publication I am using mSQL 2.0.11, PHP 4.0.1, and Apache 3.0.12. My PHP configuration is: ./configure --with-apxs=/usr/sbin/apxs --with-gettext=no --with-msql --with-pgsql --without-mysql --enable-track-vars=yes --with-pdflib=/usr/local --with-zlib --with-jpeg-dir=/usr --with-tiff-dir=/usr --with-session=/tmp --enable-trans-sid