#37652 [Opn->Bgs]: Bad Database Selected

ID: 37652 Updated by: derick@php.net Reported By: gally07 at infonie dot fr -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Windows XP Pro PHP Version: 5.1.4 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 . Previous Comments: ------------------------------------------------------------------------ [2006-05-31 13:33:34] gally07 at infonie dot fr 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 this bug report at http://bugs.php.net/?id=37652&edit=1