mysql_select_db api bug?
| From: | Jean-Pierre Arneodo | Date: | Fri, 04 Jan 2002 09:13:40 +0000 |
| Subject: | mysql_select_db api bug? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15372@lists.php.net to get a copy of this message | ||
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