";
// get items
$query = mysql_query('SELECT * FROM passendwie') 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
attribute_1=CONCAT_WS(';', attribute_1, '".mysql_real_escape_string($object->vertreiber)."'),
attribute_2=CONCAT_WS(';', attribute_2, '".mysql_real_escape_string($object->bestellcode)."')
WHERE number='".$object->nr."'
";
$query = mysql_query($sql);
if (!$query) {
echo $sql;
echo "
";
}
}
echo "ende
";
?>