Connection to Two databases simultaneously
| From: | HarryG | Date: | Sat, 02 Apr 2005 04:28:49 +0000 |
| Subject: | Connection to Two databases simultaneously | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-212071@lists.php.net to get a copy of this message | ||
Hi,
I am connecting to two database in my index.php.
Here is how:
@ $db = mysql_connect("localhost", USERLOGIN, USERDBPASS);
if (!$db)
{ print "Error: Could not connect to database. Please try again later."; exit; }
mysql_select_db(DATABASE);
@ $userdb = mysql_connect("localhost", USERLOGIN, USERDBPASS);
if (!$userdb)
{ print "Error: Could not connect to database. Please try again later."; exit; }
mysql_select_db(USERDB);
$getaccount = "SELECT * FROM account WHERE visible=1"; //Account table is present in
USERDB.
$result = mysql_query($getaccount);
$get = "SELECT * FROM useraccount"; //UserAccount table is present in DATABASE.
$result = mysql_query($get);
There is no problem with the connection. but I need to query tables in both databases. I know you
need to use link identifiers, but have had no luck in getting it to work. Appreciate your help.
Thanks.
HarryG