\n"; $result=mysql_query("select id,Name FROM worps_ukat WHERE cleared != '1'"); while($zeile=mysql_fetch_array($result)) { $ukat=$zeile["id"]; $unterkatname=$zeile["Name"]; ECHO " $unterkatname\n"; $orte=""; $ortekat=""; $ortename=""; $sresult=mysql_query("select id,Name FROM worps_okat WHERE cleared != '1'"); while($zeile=mysql_fetch_array($sresult)) { $okat=$zeile["id"]; $okatname=$zeile["Name"]; $subresult=mysql_query("select id,Firma,Vorname,Nachname FROM worps_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"]; $orte.="$ortid,"; $ortename.="$ortf $ortv $ortn,"; $ortekat.="$okat|$ukat,"; } } ECHO "$orte\n"; ECHO "$ortename\n"; ECHO "$ortekat\n"; ECHO "\n"; } ECHO "";