"AE",chr(246)=>"OE",chr(252)=>"UE",chr(223)=>"SS"));
$ort=strtoupper($ort);
$plz=$_GET["plz"];
$wo=$_GET["wo"];
if ($plz and $ort) {
$sql="SELECT loc_id,text_val,text_type from geodb_textdata where loc_id in ";
$sql.="(SELECT distinct(loc_id) from geodb_textdata where ";
$sql.="text_val like '%".$plz."%' and text_type = 500300000 and ";
$sql.="loc_id in ( SELECT loc_id from geodb_textdata where ";
$sql.="(text_val like '%".$ort."%' and text_type = 500100002))) ";
$sql.="and (text_type = 500100000 or text_type = 500300000 or text_type = 500400000) order by loc_id";
} else if ($plz) {
$sql="SELECT loc_id,text_val,text_type from geodb_textdata where text_type in ";
$sql.="(500100000,500300000,500400000) and loc_id in (";
$sql.="SELECT loc_id FROM geodb_textdata where text_val like '%".$plz."%' and text_type = 500300000) ";
$sql.="order by loc_id";
} else if ($ort) {
$sql="SELECT loc_id,text_val,text_type from geodb_textdata where text_type in ";
$sql.="(500100000,500300000,500400000) and loc_id in (";
$sql.="SELECT loc_id FROM geodb_textdata where text_val like '%".$ort."%' and text_type = 500100002) ";
$sql.="order by loc_id";
}
$rs=$_SESSION['db']->getAll($sql);
$ort="";
if ($rs) foreach ($rs as $zeile) {
if ($zeile["text_type"]==500100000) {
$ort=$zeile["text_val"];
$data[$zeile["loc_id"]]["ort"]=$zeile["text_val"];
} else if ($zeile["text_type"]==500400000) {
$data[$zeile["loc_id"]]["tel"]=$zeile["text_val"];
} else {
$data[$zeile["loc_id"]]["plz"][]=$zeile["text_val"];
}
}
$menu = $_SESSION['menu'];
?>
/main.css">