";
}
ECHO "$thumb ($katid) $katname
";
$ukats=""; $ukatsname=""; $ukatid=""; $ukatname="";
$ssubresult=mysql_query("select id,Name FROM ll_ukat WHERE cleared != '1'");
while($zeile=mysql_fetch_array($ssubresult)) {
$unterkatid=$zeile["id"];
$unterkatname=$zeile["Name"];
$subresult=mysql_query("select id FROM ll_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]) {
IF (file_exists($pfad."pics/landLeben/ukat_".$ukatid[$i]."_1.jpg")) {
$thumb="![](http://www.sonntags-einkaufen.com/LandLeben/tmp/app/icon_ukat_".$ukatid[$i]."_1.jpg)
";
} else {$thumb="";}
$ukatsname.="- $thumb $ukatname[$i] ($ukatid[$i])
";
}
}
ECHO "$ukatsname
";
}