";
// get items
$query = mysql_query('SELECT * FROM import_kundenemail') or die("Anfrage nicht erfolgreich");
$data = array();
while($obj = mysql_fetch_object($query)) {
$data[] = $obj;
}
echo "imports email
";
foreach ($data as $object) {
if ($object->email) {
$sql = "
UPDATE customers
SET
email=\"".$object->email."\"
WHERE number='".$object->knr."'
";
$query = mysql_query($sql);
if (!$query) {
echo $sql;
echo "
";
}
}
}
echo "ende
";
// get items
$query = mysql_query('SELECT * FROM import_kundenpasswort') or die("Anfrage nicht erfolgreich");
$data = array();
while($obj = mysql_fetch_object($query)) {
$data[] = $obj;
}
echo "imports passwoerter
";
foreach ($data as $object) {
if ($object->kennwort) {
$sql = "
UPDATE customers
SET
pass=\"".md5($object->kennwort)."\"
WHERE number='".$object->knr."'
";
$query = mysql_query($sql);
if (!$query) {
echo $sql;
echo "
";
}
}
}
echo "ende
";
*/
echo "get data
";
// get items
$query = mysql_query('SELECT * FROM import_kundenzahlungen') or die("Anfrage nicht erfolgreich");
$data = array();
while($obj = mysql_fetch_object($query)) {
$data[] = $obj;
}
echo "imports Zahlungsart
";
foreach ($data as $object) {
if ($object->Zahlungsart) {
$sql = "
UPDATE customers
SET
freetextfield3=\"".$object->Zahlungsart."\"
WHERE number='".$object->Kundennummer."'
";
$query = mysql_query($sql);
if (!$query) {
echo $sql;
echo "
";
}
}
}
echo "ende
";
?>