Mam problem z zrobieniem skryptu aktualizacji tabel z jedenej bazy mysql do drugiej
mam coś takiego
Kod
<?php
// z tej bazy
$dbhost1 = "local";
$dbuser1 = "ja1";
$dbpassword1 = "ja1";
$db1 = "baza1";
// do tej bazy
$dbhost2 = "local";
$dbuser2 = "ja2";
$dbpassword2 = "ja2";
$dbpassword2 = "ja2";
$db2 = "baza2";
$connection1 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
$connection2 = mysql_connect($dbhost2,$dbuser2,$dbpassword2) or die (mysql_error());
mysql_select_db($db1,$connection1);
mysql_select_db($db2,$connection2);
mysql_select_db($db1,$connection1);
mysql_select_db($db2,$connection2);
$sql = "SELECT * FROM $db.tablica1, $db2.tablica2 where $db1.tablica1.001 = $db2.tablica2.cb_001";
$results = mysql_query($sql);
while($rek = mysql_fetch_array($results)){
$staredane = $rek['055']; // kolumna 055 w baza1
$nowedane = $rek['cb_055']; // kolumna cb_055 w baza2
mysql_query("UPDATE $db1.tablica1,$db2.tablica2 SET $db2.tablica2.cb_055 = $db1.tablica1.055 WHERE $db2.tablica2.cb_001 = $db1.tablica1.001 ")or die("<br> jos_users not updated. Error is: " . mysql_error());
print "stare dane : " $staredane. ' nowe dane : ' . $nowedane. ' <br>';
}
?>
// z tej bazy
$dbhost1 = "local";
$dbuser1 = "ja1";
$dbpassword1 = "ja1";
$db1 = "baza1";
// do tej bazy
$dbhost2 = "local";
$dbuser2 = "ja2";
$dbpassword2 = "ja2";
$dbpassword2 = "ja2";
$db2 = "baza2";
$connection1 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
$connection2 = mysql_connect($dbhost2,$dbuser2,$dbpassword2) or die (mysql_error());
mysql_select_db($db1,$connection1);
mysql_select_db($db2,$connection2);
mysql_select_db($db1,$connection1);
mysql_select_db($db2,$connection2);
$sql = "SELECT * FROM $db.tablica1, $db2.tablica2 where $db1.tablica1.001 = $db2.tablica2.cb_001";
$results = mysql_query($sql);
while($rek = mysql_fetch_array($results)){
$staredane = $rek['055']; // kolumna 055 w baza1
$nowedane = $rek['cb_055']; // kolumna cb_055 w baza2
mysql_query("UPDATE $db1.tablica1,$db2.tablica2 SET $db2.tablica2.cb_055 = $db1.tablica1.055 WHERE $db2.tablica2.cb_001 = $db1.tablica1.001 ")or die("<br> jos_users not updated. Error is: " . mysql_error());
print "stare dane : " $staredane. ' nowe dane : ' . $nowedane. ' <br>';
}
?>
a potrzebuje zaktualizowac kolumne cb_055 danymi z kolumny 055 wg wspolnego mianownika cb_001=001
No i nie dziala , generalnie zawiecha