Select from a database and insert into a different database

$handle  =  mysql_connect("localhost", "username", "password") or die(mysql_error());
 
  mysql_query("USE database1",$handle);
  $query = "SELECT * FROM table";
  $result = mysql_query($query);
 
  while ($data = mysql_fetch_object($result)){
      $variable1 = $data->column1;
      $variable2 = $data->column2;
 
      mysql_query("USE database2",$handle);
      $sql = "INSERT INTO table2 SET
              col1 = '$variable1',
              col2 = '$variable2'";
     	if (!mysql_query($sql)) {
  		echo '<p>Error adding data into database: ' . mysql_error() . '</p>';
  	  }
      mysql_query("USE database1",$handle);
 
  }