It;'s entirely possible. Most database-related functions can take an
optional link identifier parameter. You didn't use it, and in that case,
database operations default to the last opened database connection. You
can however do something like:
$dblink1=mysql_connect($server1,$user1,$password1);
$dblink2=mysql_connect($server2,$user2,$password2);
mysql_select_db($database_1,$dblink1); //for link 1
mysql_select_db($dblink2,$dblink2); //for link 2
$result1=mysql_query("SELECT * from whatever",$dblink1);
while ($row=mysql_fetch_array($result1)){
$query2="insert into secondtable values ".
$row["id"].",".$row["whatever"];
$result2=mysql_query($query2,$dblink2); //insert on database 2
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
