note 38350 added to function.mysql-select-db
| From: | doug at xamo dot com | Date: | Wed, 17 Dec 2003 17:39:03 +0000 |
| Subject: | note 38350 added to function.mysql-select-db | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-62135@lists.php.net to get a copy of this message | ||
When you need to query data from multiple databases, note that mysql_select_db("db2")
doesn't prevent you from fetching more rows with result sets returned from "db1".
mysql_select_db("db1");
$res_db1=mysql_query("select * from foobar");
myqsl_select_db("db2);
$row_db1=mysql_fetch_object($res_db1);
$res_db2=mysql_query("select * from test where id='$row_db1->id'");
----
Manual Page -- http://www.php.net/manual/en/function.mysql-select-db.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+38350
Delete -- http://master.php.net/manage/user-notes.php?action=delete+38350&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+38350&report=yes
Search -- http://master.php.net/manage/user-notes.php