"; $AGENTURLink="lng=".$lng."&"; } if ($Design!="") { $AGENTURLink=$AGENTURLink."Design=".$Design."&"; $AGENTURHidden=$AGENTURHidden.""; } ?> <? echo transl($lng, $Woerter, "Agentur-Suche"); ?> " rel="stylesheet" type="text/css"> "); switch ($inifelder[34]) { case "L": print ("\n
"); break; case "C": print ("\n
"); break; case "R": print ("\n
"); break; default: print ("\n
"); break; } if (file_exists("agt.txt")) { $agtText=file("agt.txt"); for ($i=0; $i < sizeof($inizeilen); $i++) { print $agtText[$i]; } } ?>

<<
:     ">
0... 1... 2... 3... 4... 5... 6... 7... 8... 9...
Fehler beim Lesen der BusProwin-Datenbank : ".mysql_error($conn)."

"); exit; } print ("\n"); print ("\n"); print ("\n"); print ("\n"); print ("
\n"); // Agentur Übersicht ------------------------------------------------------------------------------------ $number=0; $whereBed="XXX"; $PLZSel=trim($Ausw); while ($number==0 && $whereBed!="" && (strlen($PLZSel)!=0 || $whereBed=="XXX")) { $sql = "SELECT AgenturCode, Firmierung, Name, Strasse, Land, PLZ, Ort, Telefon, Telefax, URL, eMail FROM Agenturen"; if ($PLZSel!="" && $PLZSel!="ALLE" ) { $whereBed="PLZ like '".$PLZSel."%'"; } else { $whereBed=""; } if ($whereBed != "") $sql = $sql." WHERE ".$whereBed; $sql = $sql." ORDER BY PLZ"; if ($sql != "") { $result = mysql_query($sql, $conn); if ($result) { $number = mysql_num_rows($result); if ($number > 0) { print ("\n"); $anz_Spalten=3; if ($PLZSel!="") { print (""); print (""); print (""); } $aktNr=0; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { if ($aktNr % $anz_Spalten == 0) { if ($aktNr!=0) print (""); print (""); } $aktNr++; print (""); } print ("
"); print (""); print (transl($lng, $Woerter, "Agenturen im Plz-Bereich")." : ".substr($PLZSel.".....",0,5)); print (""); print ("
"); print (""); print (trim($row["Firmierung"])); if (trim($row["Firmierung"])!="") print (" "); print (trim($row["Name"])); print ("
"); if (trim($row["Strasse"])!="") { print (trim($row["Strasse"])); print ("
"); } if (trim($row["Ort"])!="") { if (trim($row["Land"])!="" && trim($row["Land"])!="D") { print (trim($row["Land"])); print (" - "); } print (trim($row["PLZ"])); print (" "); print (trim($row["Ort"])); print ("
"); } print ("
"); if (trim($row["Telefon"])!="") { print (transl($lng, $Woerter, "Telefon")." : ".trim($row["Telefon"])); print ("
"); } if (trim($row["Telefax"])!="") { print (transl($lng, $Woerter, "Telefax")." : ".trim($row["Telefax"])); print ("
"); } if (trim($row["URL"])!="") { print (transl($lng, $Woerter, "Link")." : "); print ("".trim($row["URL"]).""); print ("
"); } if (trim($row["eMail"])!="") { print (transl($lng, $Woerter, "eMail")." : "); print ("".trim($row["eMail"]).""); print ("
"); } print ("
 "); print (""); print ("
\n"); print ("
\n"); print ("

$number ".transl($lng, $Woerter, "Agenturen")."\n"); } else { // print ("

keine Agenturen gefunden
\n"); } // print ("

Abfrage : $sql"); } else { print ("

Fehler : ".mysql_error($conn)); } } $PLZSel=substr($PLZSel,0,strlen($PLZSel)-1); } if ($number==0) print ("

".transl($lng, $Woerter, "keine Agenturen gefunden")."
\n"); // ------------------------------------------------------------------------------------------ print ("

\n"); } ?>