The function mysql_select_db set the db for one or for all link identifiers?
The table my_table is in db1 but the active database seems to be test on link #8. Here the result with PHP 4.1.0 and MySQL 3.23.41-log: mysql_pconnect() id1=Resource id #8 mysql_select_db(db1,Resource id #8) mysql_pconnect() id2=Resource id #9 mysql_select_db(test,Resource id #9) mysql_query(select * from my_table,Resource id #8) failed: Table 'test.my_table' doesn't exist Here the source: $id1=mysql_pconnect($host,$user,$pass); if($id1==false){ die("<br>mysql_pconnect() failed: ".mysql_error()); } echo "<br>mysql_pconnect() id1=$id1"; $b=mysql_select_db($db1,$id1); if($b==false){ die("<br>mysql_select_db($db1,$id1) failed: ".mysql_error()); } echo "<br>mysql_select_db($db1,$id1)"; $id2=mysql_pconnect($host,$user,$pass); if($id2==false){ echo "<br>mysql_pconnect() failed: ".mysql_error(); } echo "<br>mysql_pconnect() id2=$id2"; $b=mysql_select_db($db2,$id2); if($b==false){ die("<br>mysql_select_db($db2,$id2) failed: ".mysql_error()); } echo "<br>mysql_select_db($db2,$id2)"; $sql='select * from my_table'; $result=mysql_query($sql,$id1); if($result==false){ die("<br>mysql_query($sql,$id1) failed: ".mysql_error()); } ___________________________________________________________ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Courrier : http://courrier.yahoo.fr -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]