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