lemInsesylilt
New Member
I have two tables called clients, they are exactly the same but within two different db's. Now the master always needs to update with the secondary one. And all data should always be the same, the script runs once per day. What would be the best to accomplish this.I had the following solution but I think maybe theres a better way to do this\[code\]$sql = "SELECT * FROM client";$res = mysql_query($conn,$sql); while($row = mysql_fetch_object($res)){ $sql = "SELECT count(*) FROM clients WHERE id={$row->id}"; $res1 = mysql_query($connSecond,$sql); if(mysql_num_rows($res1) > 0){ //Update second table }else{ //Insert into second table }}\[/code\]and then I need a solution to delete all old data in second table thats not in master.Any advise help would be appreaciated