connect.2mysql databases

[GoRide_]

Hi...i have big problem...
on one php page i need to connect to 2 different mysql servers and select 2 different databases.

this will be some algorythm

connect to first server(and select database).
query(select * from table...)
while (row=mysql_fetch_array(query))
{
data1 = row[something]

////////////// here i need to connect to second server and select database
////////then

query(bla bla)

//ok...
/// now, back to first server...
query(bla)

}

and that's it.

maybe this looks stupid, or something like that...but, please tell me, is this possible and how to do it?

THANKS A LOT!

[chasiv]

You should be able to do this with 2 different connection strings...

So...

<?php
$host="[I]your_host_name_here[/I]";
$user="[I]your_user_name_here[/I]";
$password="[I]your_password_here[/I]";
$database="[I]your_db_name_here[/I]";

$db = mysql_connect($host, $user, $password);
mysql_select_db($database, $db);

$host="[I]your_host_name_here[/I]";
$user="[I]your_user_name_here[/I]";
$password="[I]your_password_here[/I]";
$database="[I]your_db_name_here[/I]";

$db2 = mysql_connect($host, $user, $password);
mysql_select_db($database, $db2);

?>

Then be sure to specify which connection to use when you do your query:

mysql_query ( string $query [, resource $link_identifier] )

So....

$strSQL = "SELECT * FROM table";
$result = mysql_query($strSQL, $db);
$row = mysql_fetch_assoc($result); // in a loop if needed as such

$strSQL2 = "SELECT * FROM table WHERE fieldname= $row['fieldname'];
$result2 = mysql_query($strSQL, $db2);

I can't test it because I don't have access where I am now... but that should work.

[GoRide_]

i already did that, on the same way you wrote.thanks a lot. a LOT. 🙂