Multiple Connections?

[Rayn]

Is it possiable to have multiple mysql database connects in the same script, and if so then how?

Thanks
- Rayn

[OhLordy]

I assume that's what the mysql anchor is for. Try this.

$conn_one = mysql_connect($host_one, $username_one, $pass_one) or die(mysql_error());

$conn_two = mysql_connect($host_two,$username_two, $pass_two) or die(mysql_error());

$db_one = mysql_select_db($db_one, $conn_one) or die(mysql_error());

$db_two = mysql_select_db($db_two, $conn_two) or die(mysql_error());

$sql_one = "SELECT FROM $table_one";
$sql_two = "SELECT FROM $table_two";

$result_one = mysql_query($sql_one,$conn_one) or die(mysql_error());

$result_two = mysql_query($sql_two, $conn_two) or die(mysql_error());

Hope this helps
Good luck
Rob

[n00854180t]

Why does that type of code always give me the "Not a valid MySQL-Link resource" then?

[ashtangiman]

The above does not work for me either (I have reposted the question since there is no answer that I have found to work).

I'm using php 4.2 with MySQL 4.0.13 on Win2k using Apache 2. Php seems to only use the last connection referenced in a mysql_select_db. So having two connections (or more) as a shortcut does not seem to work. Very strange.

Paul