[JoJo26]

I need to connect to 2 different databases on 2 different servers.

I tried:

<?php

$link1 = mysql_connect("ip here user pass")
or die("Could not connect: " . mysql_error());
mysql_select_db(stats);


$link2 = mysql_connect("ip here user pass")
or die("Could not connect: " . mysql_error());
mysql_select_db(orders);

is there anyway to keep both connections open and running so I can call variables defined in both DB's.

is this even possible?

[rec0n]

$dbc_1 = mysql_connect(...);
$dbc_2 = mysql_connect(...);
mysql_select_db('db1', $dbc_1);
mysql_select_db('db2', $dbc_2);
$query = mysql_query(..., $dbc_1);
$query = mysql_query(..., $dbc_2);

[JoJo26]

thanks for the help, greatly appreciated.