[PHP] Connecting to multiple DB's
I host a few sites, and on usually each site will have it's own MySQL database in the background. I've decided that I want to link one site to another, and need to connect to more than one database at a time. I've found that when I try to connect to 2 or more, even if I assign the other database to another variable (ie . $db1 = mysql_connect($dbhost, $dbuser, $dbpass); $db2 = mysql_connect($dbhost2, $dbuser, $dbpass); ) , the last connect called is the only one that is active. Any work arounds to this? I've been having to do it where I connect to one when needed, then connect to the other, etc. I'm thinking there has to be a better way to do this. Also, what is the function to kill a connection to a db? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Connecting to multiple DB's
Not sure about the multiple connections side, but to kill a connection: mysql_close($link); where $link is your connection variable/string hope this helps. -Patrick From: James Taylor [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: PHP List [EMAIL PROTECTED] Subject: [PHP] Connecting to multiple DB's Date: Mon, 01 Apr 2002 10:47:45 -0800 I host a few sites, and on usually each site will have it's own MySQL database in the background. I've decided that I want to link one site to another, and need to connect to more than one database at a time. I've found that when I try to connect to 2 or more, even if I assign the other database to another variable (ie . $db1 = @mysql_connect($dbhost, $dbuser, $dbpass); $db2 = @mysql_connect($dbhost2, $dbuser, $dbpass); ) , the last connect called is the only one that is active. Any work arounds to this? I've been having to do it where I connect to one when needed, then connect to the other, etc. I'm thinking there has to be a better way to do this. Also, what is the function to kill a connection to a db? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Connecting to multiple DB's
Both connects are active. you specify which link when you select the database: mysql_select_db(database_name, $db1); mysql_select_db(database_name, $db2); -Original Message- From: James Taylor [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 12:48 PM To: PHP List Subject: [PHP] Connecting to multiple DB's I host a few sites, and on usually each site will have it's own MySQL database in the background. I've decided that I want to link one site to another, and need to connect to more than one database at a time. I've found that when I try to connect to 2 or more, even if I assign the other database to another variable (ie . $db1 = @mysql_connect($dbhost, $dbuser, $dbpass); $db2 = @mysql_connect($dbhost2, $dbuser, $dbpass); ) , the last connect called is the only one that is active. Any work arounds to this? I've been having to do it where I connect to one when needed, then connect to the other, etc. I'm thinking there has to be a better way to do this. Also, what is the function to kill a connection to a db? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php