if($r==""){$r=2; $where = "adress_kat.kid=2"; }
elseif($r=="all")$where = " (adress_kat.kid=2 or adress_kat.kid=63 or adress_kat.kid=51 oradress_kat.kid=72 oradress_kat.kid=90 oradress_kat.kid=92 oradress_kat.kid=121 or adress_kat.kid=117 )";
else $where = "adress_kat.kid=$r";
$query = "select *, live_adressen.aid adid from live_adressen
left join adress_kat on adress_kat.aid = live_adressen.aid
left join live_akat on akid = adress_kat.kid where 1
and $where
group by live_adressen.aid order by field(live_adressen.ort, 'Strausberg') desc, ort, rang ";
include("intern/dbconnect/get_query.php");
$num = mysqli_num_rows($result);
if($num==1)$eintraege="Eintrag";
//echo $query;
if($num>1)$eintraege="Einträge";
echo"