function chkKdId($data) { // gibt es die Nummer schon? global $db, $file, $test; $sql = "select * from {$file} where " . $file . "number = '{$data}'"; $rs = $db->getAll($sql); if ($rs[0][$file . "number"] == $data) { // ja, eine neue holen return getKdId(); } else { return $data; } }
} else { if ($in_fld[$i] == "contact") { if ($anrede) { $vals .= "'{$anrede} {$data}',"; } else { $vals .= "'{$data}',"; } } else { $vals .= "'" . $data . "',"; } } $i++; } if (!$number) { $keys .= $file . "number,"; $vals .= "'" . getKdId() . "',"; } if ($keys != "(") { if ($test) { if ($first) { echo "<table border='1'>\n"; echo "<tr><th>" . str_replace(",", "</th><th>", substr($keys, 1, -1)) . "</th></tr>\n"; $first = false; } $vals = str_replace("',", "'</td><td>", substr($vals, 9, -1)); echo "<tr><td>" . str_replace("null,", "null</td><td>", $vals) . "</td></tr>\n"; //echo "Import $j<br>\n"; flush(); } else { $sql .= $keys . "taxzone_id,import)"; $sql .= $vals . "0,{$nun})";