Connect to 2 databases

[kbc1]

Hi all,

I am having a little problem with my connection. I have a sepearate db connection page which I include at the top of all pages and this is the content:

    

session_start();

// Connect to database 1

$remotehostname = "remotehost";
$remoteusername = "root";
$remotedatasource = "mydatabase1";
$remotepassword = "";
$remoteport = 3306;

$_SESSION['S_REMOTE_DB'] = mysql_connect($remotehostname . ":" . $remoteport, $remoteusername, $remotepassword) or die(mysql_error());
mysql_select_db($remotedatasource, $_SESSION['S_REMOTE_DB']);

// Connect to database 2

$localhostname = "localhost";
$localusername = "root";
$localdatasource = "mydatabase2";
$localpassword = "";
$localport = 3306;

$_SESSION['S_LOCAL_DB'] = mysql_connect($localhostname . ":" . $localport, $localusername, $localpassword) or die(mysql_error());
mysql_select_db($localdatasource, $_SESSION['S_LOCAL_DB']);

When selecting data from my database I choose which database to connect to like such:

$dataresult = mysql_query($sqlquery, $_SESSION['S_REMOTE_DB']);

OR 

$dataresult = mysql_query($sqlquery, $_SESSION['S_LOCAL_DB'])

For some reason it is failing and only works if I remove one of the connection types from my DB header page.

Any suggestion on how to get them both working?

K

[thorpe]

I wouldn't save connection resources in the $_SESSION array. You simply dont need to if your including the connection page anyway and its a very inificient way of trying to persist a connection. In fact, I dont think it will work.

Just use nomal variables.

[samudasu]

This is taken directly from the php manual.

Warning
Some types of data can not be serialized thus stored in sessions. It includes resource variables or objects with circular references (i.e. objects which passes a reference to itself to another object).