- ";
$result=mysql_query("select id,Name FROM helgo_okat WHERE cleared != '1' AND Name != ''");
while($zeile=mysql_fetch_array($result)) {
$katid=$zeile["id"];
$katname=$zeile["Name"];
IF (file_exists($pfad."pics/helgoland/okat_".$katid."_1.jpg")) {
$thumb="
- $katname
- $ukatname[$i] "; } } ECHO "$ukatsname
![](http://www.sonntags-einkaufen.com/helgoland/tmp/app/icon_okat_".$katid."_1.jpg){kind=icon}
";
}
ECHO "- ";
$ukats=""; $ukatsname=""; $ukatid=""; $ukatname="";
$ssubresult=mysql_query("select id,Name FROM helgo_ukat WHERE cleared != '1'");
while($zeile=mysql_fetch_array($ssubresult)) {
$unterkatid=$zeile["id"];
$unterkatname=$zeile["Name"];
$subresult=mysql_query("select id FROM helgo_adresse WHERE cleared != '1' AND ((Oberkat = '$katid' AND Unterkat = '$unterkatid') OR (Oberkat2 = '$katid' AND Unterkat2 = '$unterkatid') OR (Oberkat3 = '$katid' AND Unterkat3 = '$unterkatid') OR (Oberkat4 = '$katid' AND Unterkat4 = '$unterkatid') OR (Oberkat5 = '$katid' AND Unterkat5 = '$unterkatid'))");
while($zeile=mysql_fetch_array($subresult)) {
$ortid=$zeile["id"];
IF (!in_array($unterkatid,$ukatid)) {
$ukatid[]=$unterkatid;
$ukatname[]=$unterkatname;
}
}
}
$mng=count($ukatid);
ksort($ukatid);
reset($ukatid);
FOR ($i=0; $i<$mng; $i++) {
IF ($ukatid[$i] AND $okat == $katid) {
$ukatsname.="