|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2002-03-11 07:24 UTC] newspost at jerviss dot org
[2002-03-11 08:34 UTC] mfischer@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2026 The PHP GroupAll rights reserved. |
Last updated: Fri Feb 20 21:00:01 2026 UTC |
PHP 4.1.0 and MySQL 3.23.41-log The function mysql_select_db set the db for other link identifiers than specified. Doc: bool mysql_select_db (string database_name, resource [link_identifier]) mysql_select_db() sets the current active database on the server that's associated with the specified link identifier. If no link identifier is specified, the last opened link is assumed. If no link is open, the function will try to establish a link as if mysql_connect() was called without arguments, and use it. The table my_table is in db1 but the active database seems to be test on link #8. Here the result: 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()); }