"; echo "
"; echo " |
|
"; } info_top(); if ($gesendet) { include("include/connect.php3"); $db = db_connection(); if ($auswahl == 'Stichwort') { $sqlab = "select * from heilpraktiker where name like '%$suchtext%' OR info like '%$suchtext%' OR Ort like '$suchtext%' OR plz like '$suchtext%'"; } else if ($auswahl == 'Name') { $sqlab = "select * from heilpraktiker where name like '%$suchtext%'"; } else if ($auswahl == 'PLZ') { $sqlab = "select * from heilpraktiker where plz like '$suchtext%'"; } else if ($auswahl == 'Ort') { $sqlab = "select * from heilpraktiker where ort like '$suchtext%'"; } $res = mysql_db_query("ws10869_1", $sqlab); if (mysql_num_rows($res)); { $num = mysql_num_rows($res); //Tabellenbeginn echo "
| ||||||||||
";
for ($i=0; $i<$num; $i++)
{
$sname = mysql_result($res, $i, "name");
$sstrasse = mysql_result($res, $i, "strasse");
$splz = mysql_result($res, $i, "plz");
$sort = mysql_result($res, $i, "ort");
$stel = mysql_result($res, $i, "tel");
$sfax = mysql_result($res, $i, "fax");
$surl = mysql_result($res, $i, "url");
$semail = mysql_result($res, $i, "email");
$sinfo = mysql_result($res, $i, "info");
$spartner = mysql_result($res, $i, "partner");
if ($surl == "http://") {
$surl = "";
}
echo "
"; } echo " |