multiple database connection

[Anon]

Is there a way to connect to 2 mysql databases? (Using the same host)

I could realy appreciate any help given

[Anon]

You can connect to multiple DB's from one host, just specify the hostname, username and password for the server in mysql_connect().

[Anon]

i have try it using an array,
$conn["master"] = mysql_connect(......);
$conn["second"] = mysql_connect(......);

but it's seem like using connection variable

$masterConn = mysql_connect(......);
$secondConn = mysql_connect(......);

where the difference?????? 🙁

[g_orfan]

Perhaps I didn't make myself very clear. What I am trying to do is to have 2 connections to 2 different databases using the same host. (In 1 .php page)
Thanks very much for the tips guys. I don't think what am i trying to do is feasible, but at least I wouldn't waste more time

[g_orfan]

Perhaps I didn't make myself very clear. What I am trying to do is to have 2 connections to 2 different databases using the same host. (In 1 .php page)

and updating/retrieving 2 tables in these 2 databases

Thanks very much for the tips guys. I don't think what am i trying to do is feasible, but at least I wouldn't waste more time

[Anon]

Have you tried like this:

$database = mysql_select_db("db1", "db2");

chew

[Anon]

I don't understand your issues here. Make the second connection the same way you made the first, just use a different link identifier for each.

[g_orfan]

I've tried it but still it will open a connection to one of the 2 databases.

$db = mysql_connect("localhost", "root", "demonakos");

$db2 = mysql_connect("localhost", "root", "demonakos");

mysql_select_db("global",$db);

mysql_select_db("staff",$db2);

even this failed

$db = mysql_connect("localhost", "root", "demonakos");

mysql_select_db("global",$db);
mysql_select_db("staff",$db);

[Anon]

Saw this in the manual. I don't know if it is acurate.

[e-mail]
19-Feb-2002 07:04

If you want to connect to the same server twice and open connections to two
different databases (since it's easier to access them with different link
resource ids instead of doing a select_db each time, and this means you
can easily put the two databases on different servers later), you'll need
to use different usernames or passwords for the two connections. Otherwise
PHP will "intelligently" ignore the second connection.