Re: Opening more than one database at a time?

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 }