'000' ORDER BY kat_id"; $erg = do_query($conn_id,$query); $a = ""; return $a; } echo "
"; echo ""; echo ""; echo " "; echo ""; echo ""; echo " "; echo " "; echo ""; echo "
"; echo "

DEAFLINKS

"; echo "
"; echo "Kategorie "; echo DropdownKategorie('kat',$kat); if ($kat<>'000') { echo DropdownUnterkategorie('unterkat',$kat); } echo " "; echo "Land "; echo DropdownLand('land',$land); echo "
"; echo "
"; $land = addslashes($land); $plz = addslashes($plz); $iLink = "link.php3?kat=000&plz=$plz&land=$land"; $nachname = addslashes($nachname); if ($kat=="0" OR $kat==""){ echo "

"; echo "Alle "; echo "A "; echo "B "; echo "C "; echo "D "; echo "E "; echo "F "; echo "G "; echo "H "; echo "I "; echo "J "; echo "K "; echo "L "; echo "M "; echo "N "; echo "O "; echo "P "; echo "Q "; echo "R "; echo "S "; echo "T "; echo "U "; echo "V "; echo "W "; echo "X "; echo "Y "; echo "Z "; echo "

"; } $info = read_dbinfo(); $dbverbindung = do_connect($info['host'],$info['dbname'],$info['username'],$info['password']); $abfrage = "SELECT kat, bezeichnung, vorname, nachname, land, ort, internet, bemerkung, bearbeiter, name, kat_id, kat as s1, nachname as s2 FROM anschriften, kategorie WHERE kat = kat_id AND kat LIKE '$kat%' AND land LIKE '$land%' AND plz LIKE '$plz%' AND nachname LIKE '$nachname%' AND internet <> '' ORDER BY s1, ort, bezeichnung, s2"; $erg = do_query($dbverbindung,$abfrage); $anz = mysql_num_rows($erg); if ($anz==0) { echo "

Keine Anschriften gefunden

";} echo ""; for ($i=0 ; $i";} $alt=$name; } echo " "; echo ""; echo ""; echo " "; } $alt=""; echo "

$name [nach oben]

"; echo " ".$ort; echo ""; if ($kat=="000") { echo "$nachname $vorname\n"; } elseif($kat=="9" or $kat=="900" or $kat=="901" or $kat=="902" or $kat=="903") { echo "$bezeichnung
$bemerkung\n"; } else { echo "$bezeichnung\n"; } echo "
"; do_disconnect($dbverbindung); ?>