title: Copy some MySQL rows between two different database connection via PHP
body: <p>I want to copy some rows from srcdb.srctb to dstdb.dsttb that, those are in do separate servers with different user and password access. Due to in PHP we can use one connection resource in <code>mysql_query()</code>, how can I do run my query? for example:</p>
  
  <pre><code>$dblink_src = ($srchost, $srcuser, $srcpass);
  $dblink_dst = ($dsthost, $dstuser, $dstpass);
  mysql_query('insert into dstdb.dsttb select * from srcdb.srctb as mysrc where mysrc.provid=8', ????);
  </code></pre>
  
  <p>I don't know what should I put instead of "????" because, I can just use one database connection, but I need 2 to specify two different database connection.</p>