connecting to 2 mysql databases problem?

[dragonusthei]

Hi how would i make this work?

$db1 = mysql_connect();

$db1_select = mysql_select_db();

$db2 = mysql_connect();

$db2_select = mysql_select_db();

//code goes here

[phil88]

Depends what you  mean by work?


With mysql_select_db(), you can chuck it 2 parameters, the database and the connection to use. So with your code, you could do;

$db1 = mysql_connect("Host", "username", "password");
$db1_select = mysql_select_db("DatabaseName", $db1);

$db2 = mysql_connect("Host", "username", "password");
$db2_select = mysql_select_db("DatabaseName", $db2);

Obviously replacing host, username, password and databasename with the actual data.