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]

Reply via email to