query("SELECT dst_id, bezeichnung, name, str, plz, ort, mail, date_format(gueltig_von, '%d.%m.%Y') gueltig_von_form, date_format(gueltig_bis, '%d.%m.%Y') gueltig_bis_form, gueltig_von, gueltig_bis FROM dvm_dienststellen WHERE upper(name) LIKE '%" . strtoupper($_GET['search']) . "%' OR plz LIKE '%" . $_GET['search'] . "%' OR bezeichnung LIKE '%" . $_GET['search'] . "%' ORDER BY name ASC"); echo " "; while($row = $result1->fetch_array()) { if($row['gueltig_von'] != '0000-00-00'){ $gueltig_von = $row['gueltig_von_form']; }else{ $gueltig_von = ''; } if($row['gueltig_bis'] != '0000-00-00'){ $gueltig_bis = $row['gueltig_bis_form']; }else{ $gueltig_bis = ''; } $lnnr++; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo "

#	Behördenart	Name	Straße	PLZ	Ort	Mailadresse	Gültig von	Gültig bis	Edit
'; echo $lnnr; echo '	'; echo preg_replace('/(' . $_GET['search'] . ')/Usi', '\\1', $row['bezeichnung']); echo '	'; echo preg_replace('/(' . $_GET['search'] . ')/Usi', '\\1', $row['name']); echo '	'; echo preg_replace('/(' . $_GET['search'] . ')/Usi', '\\1', $row['str']); echo '	'; echo preg_replace('/(' . $_GET['search'] . ')/Usi', '\\1', $row['plz']); echo '	'; echo preg_replace('/(' . $_GET['search'] . ')/Usi', '\\1', $row['ort']); echo '	'; echo preg_replace('/(' . $_GET['search'] . ')/Usi', '\\1', $row['mail']); echo '	'; echo preg_replace('/(' . $_GET['search'] . ')/Usi', '\\1', $gueltig_von); echo '	'; echo preg_replace('/(' . $_GET['search'] . ')/Usi', '\\1', $gueltig_bis); echo '	'; echo ''; echo '

"; ?>