<?php
$tbl = "table";
$field = "field";
$mysql_hostSRC = "";
$mysql_userSRC = "root";
$mysql_pwdSRC = "";
$db_SRC ="src";
$databaseSRC = mysql_connect($mysql_hostSRC,$mysql_userSRC,$mysql_pwdSRC) or die("stopted".mysql_error());
mysql_select_db($db_SRC);//$database = the connection to the database
$res = mysql_query("SELECT * FROM $db_SRC.$tbl;",$databaseSRC);
$mysql_hostDEST = "";
$mysql_userDEST = "root";
$mysql_pwdDEST = "";
$db_DEST ="dest";
$databaseDEST = mysql_connect($mysql_hostDEST,$mysql_userDEST,$mysql_pwdDEST) or die("stopted".mysql_error());
mysql_select_db($db_DEST);//$database = the connection to the database
$return =0;
$delivered = 0;
while ($row = mysql_fetch_assoc($res)){
if ($row[$field]==''){
$return++;
$sql = "update $tbl SET $tbl.`$field`='Y' where ;";//TODO...
print $sql;
$resA = mysql_query($sql,$databaseDEST);
print ($resA)?"` [ok]<br>":"<br>";
}
if($row[$field]!=''){
$delivered++;
$sql = "update $tbl SET $tbl.`$field`='".$row['field']."' where ;";
print $sql;
$resB = mysql_query($sql,$databaseDEST);
print ($resB)?"` [ok]<br>":"<br>";
}
}
@mysql_close($database);
?>