";
// get items
$sql = "SELECT i.id, i.detail_description, iim.beschreibung FROM import_item_merkmale iim
LEFT JOIN items i ON i.old_id=iim.lid
WHERE iim.mid=77
";
$query = mysql_query($sql) or die("Anfrage nicht erfolgreich");
$data = array();
while($obj = mysql_fetch_object($query)) {
$data[] = $obj;
}
echo "imports
";
foreach ($data as $object) {
$sql = "
UPDATE items SET
detail_description=CONCAT(detail_description,'".mysql_real_escape_string('
'.$object->beschreibung)."')
WHERE id='".$object->id."'
";
$query = mysql_query($sql);
if (!$query) {
echo $sql;
echo "
";
}
}
echo "ende
";
?>