Zurück
";
$result=mysql_query("select id,Name FROM helgo_ukat WHERE id = '$ukat'");
while($zeile=mysql_fetch_array($result)) {
$unterkatname=$zeile["Name"];
ECHO "$unterkatname
";
$subresult=mysql_query("select id,Firma,Vorname,Nachname FROM helgo_adresse WHERE cleared != '1' AND ((Oberkat='$okat' AND Unterkat = '$ukat') OR (Oberkat2='$okat' AND Unterkat2 = '$ukat') OR (Oberkat3='$okat' AND Unterkat3 = '$ukat') OR (Oberkat4='$okat' AND Unterkat4 = '$ukat') OR (Oberkat5='$okat' AND Unterkat5 = '$ukat'))");
while($zeile=mysql_fetch_array($subresult)) {
$ortid=$zeile["id"];
$ortf=$zeile["Firma"];
$ortv=$zeile["Vorname"];
$ortn=$zeile["Nachname"];
$thumb="";
IF (file_exists($pfad."pics/helgoland/adr_".$ortid."_1.jpg")) {
$thumb="![](http://www.sonntags-einkaufen.com/helgoland/tmp/app/icon_adr_".$ortid."_1.jpg)
";
}
ECHO "$thumb $ortid $ortf $ortv $ortn ";
}
}