From: nerdystudmuffin at gmail dot com Operating system: Linux, XP, NT, 2K PHP version: 5.1.6 PHP Bug Type: MySQL related Bug description: 2 connections with same server/auth selecting diff dbs
Description: ------------ Generating two database handles to the same server with the same authentication and selecting different databases for them. They act as a single connection and will only return results from the last database selected. Reproduce code: --------------- $server ="localhost"; $user="sql_admin"; $pass="password"; $num_query = "SELECT * FROM aqs_users WHERE 1"; $num_db = "aqs"; $anum_query = "SELECT * FROM w_dagent_hierarchy WHERE row_date='2005-08-08'"; $anum_db = "dbviews"; $num = mysql_connect($server,$user,$pass); $anum = mysql_connect($server,$user,$pass); ### LINEAR mysql_select_db($num_db,$num); mysql_select_db($anum_db,$anum); $num_res = mysql_query($num_query,$num); $anum_res = mysql_query($anum_query,$anum); $num_row = mysql_fetch_row($num_res); $anum_row = mysql_fetch_row($anum_res); echo "<pre>"; print_r($num_row); echo "</pre>"; echo "<pre>"; print_r($anum_row); echo "</pre>"; mysql_close($num); mysql_close($anum); unset($num_res); unset($anum_res); unset($num_row); unset($anum_row); echo "<hr>"; $num = mysql_connect($server,$user,$pass); $anum = mysql_connect($server,$user,$pass); mysql_query("USE aqs",$num); mysql_query("USE dbviews",$anum); $num_res = mysql_query($num_query,$num); $anum_res = mysql_query($anum_query,$anum); $num_row = mysql_fetch_row($num_res); $anum_row = mysql_fetch_row($anum_res); echo "<pre>"; print_r($num_row); echo "</pre>"; echo "<pre>"; print_r($anum_row); echo "</pre>"; mysql_close($num); mysql_close($anum); unset($num_res); unset($anum_res); unset($num_row); unset($anum_row); Expected result: ---------------- I would expect both querys to run and display a formatted print_r() of the results. Actual result: -------------- Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\AQS\testme.php on line 64 Array ( [0] => 1 [1] => CENSORED [2] => CENSORED [3] => 15 [4] => 0 [5] => 4 ) Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\AQS\testme.php on line 82 Array ( [0] => 2005-08-08 [1] => 0011f25.0000010 [2] => 2300 [3] => CENSORED [4] => [5] => CENSORED [6] => CENSORED [7] => 0021d02.0000004 [8] => Mid [9] => CENSORED [10] => CENSORED [11] => Full-time [12] => CENSORED [13] => 2003-12-08 [14] => 0000-00-00 ) -- Edit bug report at http://bugs.php.net/?id=38689&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38689&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38689&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38689&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=38689&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=38689&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=38689&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=38689&r=needscript Try newer version: http://bugs.php.net/fix.php?id=38689&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=38689&r=support Expected behavior: http://bugs.php.net/fix.php?id=38689&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=38689&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=38689&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=38689&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38689&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=38689&r=dst IIS Stability: http://bugs.php.net/fix.php?id=38689&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=38689&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=38689&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=38689&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=38689&r=mysqlcfg