Thanks guys for your help. Its greatly appreciated.
sleipnir214 is it possible to do this:
$result1 = mysql_query ("Insert into the_table (select * from thetable1,$dbh1)", $dbh2);
Basically, this will insert all data from thetable1 table in the first database, into the second database in a...