$r = mysql_unbuffered_query("SELECT * FROM XXXX",$con_2); while($row = mysql_fetch_assoc($r)){ mysql_query("INSERT INTO .........................",$con_1); }