From: gally07 at infonie dot fr
Operating system: Windows XP Pro
PHP version: 5.1.4
PHP Bug Type: MySQL related
Bug description: Bad Database Selected
Description:
------------
Hi,
I've got 2 connections on a server MysQL but to two databases different in
a same time, and the two connection want to execute herself on the same
database.
The message is that's table "blabla" not exist on database 1, but the
database selected with mysql_select_db() on the database 2.
I don't have any problem with php 5.1.2
Reproduce code:
---------------
<?php
$cnx1 = mysql_connect('localhost', 'haha', 'hoho');
$cnx2 = mysql_connect('localhost', 'haha', 'hoho');
mysql_select_db('db1', $cnx1);
mysql_select_db('db2', $cnx2);
mysql_query('SELECT * from TABLE1', $cnx2);
Expected result:
----------------
Table TABLE1 doesn't exist
--
Edit bug report at http://bugs.php.net/?id=37652&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=37652&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=37652&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=37652&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37652&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=37652&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=37652&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=37652&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=37652&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=37652&r=support
Expected behavior: http://bugs.php.net/fix.php?id=37652&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=37652&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=37652&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37652&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37652&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37652&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=37652&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=37652&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=37652&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=37652&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=37652&r=mysqlcfg
