Auf Thema antworten 2026

Beitrag

<blockquote data-quote="mathi77" data-source="post: 1342478" data-attributes="member: 269794">Hallo Ihr Lieben,bitte um Eure Hilfe, habe meine Firmenabfrage nun mit weiteren Input-Felder ausgebaut und plötzlich funktioniert meine Blätterfunktion nicht mehr <img src="/styles/default/xenforo/smilies/uhm.gif"&nbsp; class="smilie" loading="lazy" alt=":(" title="Frown&nbsp; &nbsp; :(" data-shortname=":(" /> // SEITEN BLAETTERN AUSGEBENDie Url wird aber richtig angezeigt, erst beim erneuten anklicken des Suchbuttons wird die zB. die 2. Seite gezeigt!Habt Ihr einen Tipp? Danke &amp; lg Mathi[php]&lt;?php &nbsp; &nbsp; // $seite DEFINIEREN&nbsp; &nbsp; if(isset($_GET[&#039;seite&#039;])){&nbsp; &nbsp; &nbsp; &nbsp; $seite=strip_tags($_GET[&#039;seite&#039;]); // &#039;BÖSEN&#039; CODE ENTFERNEN (strip_tags)&nbsp; &nbsp; &nbsp; &nbsp; $seite=trim($seite); // ÜBERFLÜSSIGE LEERZEICHEN, TABS &amp; CO VOR UND NACH DEM EIGENTLICHEN INHALT ENTFERNEN (trim)&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; else {&nbsp; &nbsp; &nbsp; &nbsp; $seite=1;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; // $seite DEFINIEREN ENDE&nbsp; &nbsp; &nbsp; &nbsp; $ZeilenProSeite = 5; // ANZAHL EINTRÄGE PRO SEITE AUS DB&nbsp; &nbsp; $start=$seite*$ZeilenProSeite-$ZeilenProSeite; // START FÜR LIMIT ($sql) BERECHENEN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // $suche DEFINIEREN&nbsp; &nbsp; if(isset($_POST[&#039;s&#039;])){&nbsp; &nbsp; &nbsp; &nbsp; $suche=strip_tags($_POST[&#039;s&#039;]);&nbsp; &nbsp; &nbsp; &nbsp; $suche=trim($suche); &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; else{&nbsp; &nbsp; &nbsp; &nbsp; $suche=&#039;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; // HIER KÖNNTE MAN AUCH EINEN STANDARDWERT FESTLEGEN, ZUM BEISPIEL &#039;ALLE&#039;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; // $suche DEFINIEREN ENDE?&gt;&nbsp; &nbsp; &lt;div id=&quot;filter&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;table cellspacing=&quot;0&quot; cellpadding=&quot;2&quot; border=&quot;0&quot; width=&quot;100%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;form name=&quot;frm&quot; id=&quot;frmSuche&quot; method=&quot;post&quot; action=&quot;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody border=&quot;1&quot; bordercolor=&quot;#E1E1E1&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;strong&gt;Firmen&lt;/strong&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td colspan=&quot;1&quot; align=&quot;center&quot;&gt;&nbsp; &nbsp; &lt;a href=&quot;eManager.php?page=firmaneu&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;images/neu.gif&quot; alt=&quot;neue Firma&quot;/&gt;&lt;/a&gt;&lt;br/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a href=&quot;eManager.php?page=firmaneu&quot;&gt;neue Firma&lt;/a&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td align=&quot;center&quot; colspan=&quot;4&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;ALLE&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;0-9&quot; name=&quot;s&quot;/&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;A&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;B&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;C&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;D&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;E&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;F&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;G&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;H&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;I&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;J&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;K&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;L&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;M&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;N&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;O&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;P&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;Q&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;R&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;S&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;T&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;U&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;V&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;W&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;X&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;Y&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;Z&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td colspan=&quot;3&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;form id=&quot;suchen&quot; method=&quot;POST&quot; action=&quot;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label for=&quot;sucheFirma&quot;&gt;Firma:&amp;nbsp;&lt;/label&gt;&lt;input type=&quot;text&quot; value=&quot;&quot; name=&quot;sucheFirma&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label for=&quot;sucheStrasse&quot;&gt;Strasse:&amp;nbsp;&lt;/label&gt;&lt;input type=&quot;text&quot; value=&quot;&quot; name=&quot;sucheStrasse&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label for=&quot;suchePLZ&quot;&gt;PLZ:&amp;nbsp;&lt;/label&gt;&lt;input type=&quot;text&quot; value=&quot;&quot; id=&quot;suchePLZ&quot; name=&quot;suchePLZ&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label for=&quot;sucheOrt&quot;&gt;ORT:&amp;nbsp;&lt;/label&gt;&lt;input type=&quot;text&quot; value=&quot;&quot; name=&quot;sucheOrt&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label for=&quot;sucheVorname&quot;&gt;Ansprechperson:&amp;nbsp;&lt;/label&gt;&lt;input type=&quot;text&quot; value=&quot;&quot; name=&quot;sucheVorname&quot;/&gt;&lt;input type=&quot;text&quot; value=&quot;&quot; name=&quot;sucheNachname&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;select name=&quot;verkaeufer&quot; size=&quot;1&quot; id=&quot;verkaeufer&quot; &gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value=&quot;0&quot;&gt;Verk&amp;auml;ufer&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;SELECT id_Benutzer, nachname FROM tbl_benutzerdaten ORDER BY nachname ASC&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $result = mysql_query($sql) or die(&quot;ERROR: &quot;.mysql_error());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($data = mysql_fetch_array($result)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;option value=&quot;&#039;.$data[&#039;id_Benutzer&#039;].&#039;&quot;&gt;&#039;.$data[&#039;nachname&#039;].&#039;&lt;/option&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;SUCHE&quot; name=&quot;s&quot;/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td align=&quot;right&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;colgroup&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;col width=&quot;30&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;col width=&quot;200&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;col width=&quot;200&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;col width=&quot;200&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;col width=&quot;50&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;col width=&quot;100&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;col width=&quot;100&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/colgroup&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;thead&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;th scope=&quot;col&quot;&gt;&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;th scope=&quot;col&quot;&gt;Firma&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;th scope=&quot;col&quot;&gt;Ansprechperson&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;th scope=&quot;col&quot;&gt;Adresse&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;th scope=&quot;col&quot;&gt;PLZ&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;th scope=&quot;col&quot;&gt;Ort&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;th scope=&quot;col&quot;&gt;Telnr&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/thead&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($suche){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($suche==&#039;ALLE&#039;){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $where=&#039;&#039;;&nbsp; // ALLE DATENSÄTZE ANZEIGEN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; elseif($suche==&#039;0-9&#039; || preg_match(&#039;/^[a-zA-Z]$/&#039;, $suche)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $suche=strtoupper($suche);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $where=&quot; WHERE Firma REGEXP &#039;^[&quot; . mysql_real_escape_string($suche) . &quot;]&#039;&quot;; // DATENSÄTZE DIE MIT BUCHSTABE ODER ZAHL AUS $suche BEGINNEN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $where=&quot; WHERE Firma LIKE &#039;%&quot; . mysql_real_escape_string($_POST[&#039;sucheFirma&#039;]) . &quot;%&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND faStrasse LIKE &#039;%&quot; . mysql_real_escape_string($_POST[&#039;sucheStrasse&#039;]) . &quot;%&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND faPLZ LIKE &#039;%&quot; . mysql_real_escape_string($_POST[&#039;suchePLZ&#039;]) . &quot;%&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND faOrt LIKE &#039;%&quot; . mysql_real_escape_string($_POST[&#039;sucheOrt&#039;]) . &quot;%&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND faVorname LIKE &#039;%&quot; . mysql_real_escape_string($_POST[&#039;sucheVorname&#039;]) . &quot;%&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND faNachname LIKE &#039;%&quot; . mysql_real_escape_string($_POST[&#039;sucheNachname&#039;]) . &quot;%&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($_POST[&#039;verkaeufer&#039;]&gt;0) { $where.= &quot;AND fid_benutzer=&quot;.$_POST[&#039;verkaeufer&#039;];}&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // GESAMTANZAHL ERMITTELN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;SELECT COUNT(idFirma) FROM tbl_firmen&quot; . $where;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $result = mysql_query($sql) or die(&quot;ERROR: &quot;.mysql_error());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $anzahl = mysql_result($result, 0);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // GESAMTANZAHL ERMITTELN ENDE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($anzahl==0){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;p class=&quot;Eintrag&quot;&gt;Leider verlief die Suche ohne Erfolg!&lt;/p&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($anzahl==1){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;p class=&quot;Eintrag&quot;&gt;1 Eintrag gefunden&lt;/p&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;p class=&quot;Eintrag&quot;&gt;&#039; . $anzahl . &#039; Eintr&amp;auml;ge gefunden&lt;/p&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;SELECT * FROM tbl_firmen&quot; . $where . &quot; ORDER BY Firma LIMIT &quot; . $start . &quot;, &quot; . $ZeilenProSeite;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $result = mysql_query($sql) or die(&quot;ERROR: &quot;.mysql_error());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysql_num_rows($result)&gt;=1){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;tbody&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $nr=1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_object($result)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($nr % 2 == 0 ){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $wert = &#039;bgFarbe1&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $wert = &#039;bgFarbe2&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;form name=&quot;frmAnzeige&quot; id=&quot;frmAnzeige&quot; method=&quot;GET&quot; action=&quot;fa_details.php&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr class=&quot;&#039;.$wert.&#039;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td align=&quot;center&quot;&gt;&#039;.($nr+$start).&#039;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;hidden&quot; name=&quot;idFirma&quot; value=&quot;&#039;.$row-&gt;idFirma.&#039;&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;a href=&quot;&#039; . $_SERVER[&#039;PHP_SELF&#039;] . &#039;?page=fa_details&amp;id=&#039;.$row-&gt;idFirma.&#039;&quot;&gt;&#039;.$row-&gt;Firma.&#039;&lt;/a&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&#039;.$row-&gt;faVorname.&#039;&amp;nbsp;&#039;.$row-&gt;faNachname.&#039;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&#039;.$row-&gt;faStrasse.&#039;&amp;nbsp;&#039;.$row-&gt;faHausnr.&#039;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&#039;.$row-&gt;faPLZ.&#039;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&#039;.$row-&gt;faOrt.&#039;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&#039;.$row-&gt;faTelVW.&#039;&amp;nbsp;&#039;.$row-&gt;faTelNR.&#039;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $nr++;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;/tbody&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;p class=&quot;Eintrag&quot;&gt;Seite &#039; . $seite . &#039; existiert nicht!&lt;/p&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // SEITEN BLAETTERN AUSGEBEN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $gesamtseiten=ceil($anzahl/$ZeilenProSeite);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;p class=&quot;link&quot;&gt;Seite&amp;nbsp;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for($i=1;$i&lt;=$gesamtseiten;$i++){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($i==$seite){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;b&gt;[&#039; . $i . &#039;]&lt;/b&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;[&lt;a href=&quot;&#039; . $_SERVER[&#039;PHP_SELF&#039;] . &#039;?page=firmen&amp;seite=&#039; . $i . &#039;&amp;amp;s=&#039; . $suche . &#039;&quot;&gt;&#039; . $i . &#039;&lt;/a&gt;]&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;/p&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // SEITEN BLAETTERN AUSGEBEN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;p class=&quot;Eintrag&quot;&gt;Bitte geben Sie einen Suchbegriff ein!&lt;/p&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/div&gt;&lt;!-- end filter --&gt;[/php]</blockquote>

[QUOTE="mathi77, post: 1342478, member: 269794"] Hallo Ihr Lieben, bitte um Eure Hilfe, habe meine Firmenabfrage nun mit weiteren Input-Felder ausgebaut und plötzlich funktioniert meine Blätterfunktion nicht mehr :( [COLOR=#000000][COLOR=#FF8000]// SEITEN BLAETTERN AUSGEBEN[/COLOR][/COLOR] Die Url wird aber richtig angezeigt, erst beim erneuten anklicken des Suchbuttons wird die zB. die 2. Seite gezeigt! Habt Ihr einen Tipp? Danke & lg Mathi [php] <?php // $seite DEFINIEREN if(isset($_GET['seite'])){ $seite=strip_tags($_GET['seite']); // 'BÖSEN' CODE ENTFERNEN (strip_tags) $seite=trim($seite); // ÜBERFLÜSSIGE LEERZEICHEN, TABS & CO VOR UND NACH DEM EIGENTLICHEN INHALT ENTFERNEN (trim) } else { $seite=1; } // $seite DEFINIEREN ENDE $ZeilenProSeite = 5; // ANZAHL EINTRÄGE PRO SEITE AUS DB $start=$seite*$ZeilenProSeite-$ZeilenProSeite; // START FÜR LIMIT ($sql) BERECHENEN // $suche DEFINIEREN if(isset($_POST['s'])){ $suche=strip_tags($_POST['s']); $suche=trim($suche); } else{ $suche=''; // HIER KÖNNTE MAN AUCH EINEN STANDARDWERT FESTLEGEN, ZUM BEISPIEL 'ALLE' } // $suche DEFINIEREN ENDE ?> <div id="filter"> <table cellspacing="0" cellpadding="2" border="0" width="100%"> <form name="frm" id="frmSuche" method="post" action=""> <tbody border="1" bordercolor="#E1E1E1"> <tr> <td>Firmen</td> <td colspan="1" align="center"> <a href="eManager.php?page=firmaneu"><img border="0" src="images/neu.gif" alt="neue Firma"/></a> <a href="eManager.php?page=firmaneu">neue Firma</a> </td> </tr> <tr> <td align="center" colspan="4"> <input type="submit" value="ALLE" name="s"/> <input type="submit" value="0-9" name="s"/> <input type="submit" value="A" name="s"/> <input type="submit" value="B" name="s"/> <input type="submit" value="C" name="s"/> <input type="submit" value="D" name="s"/> <input type="submit" value="E" name="s"/> <input type="submit" value="F" name="s"/> <input type="submit" value="G" name="s"/> <input type="submit" value="H" name="s"/> <input type="submit" value="I" name="s"/> <input type="submit" value="J" name="s"/> <input type="submit" value="K" name="s"/> <input type="submit" value="L" name="s"/> <input type="submit" value="M" name="s"/> <input type="submit" value="N" name="s"/> <input type="submit" value="O" name="s"/> <input type="submit" value="P" name="s"/> <input type="submit" value="Q" name="s"/> <input type="submit" value="R" name="s"/> <input type="submit" value="S" name="s"/> <input type="submit" value="T" name="s"/> <input type="submit" value="U" name="s"/> <input type="submit" value="V" name="s"/> <input type="submit" value="W" name="s"/> <input type="submit" value="X" name="s"/> <input type="submit" value="Y" name="s"/> <input type="submit" value="Z" name="s"/> </td> </tr> </form> <tr> <td colspan="3"> <form id="suchen" method="POST" action=""> <label for="sucheFirma">Firma: </label><input type="text" value="" name="sucheFirma"/> <label for="sucheStrasse">Strasse: </label><input type="text" value="" name="sucheStrasse"/> <label for="suchePLZ">PLZ: </label><input type="text" value="" id="suchePLZ" name="suchePLZ"/> <label for="sucheOrt">ORT: </label><input type="text" value="" name="sucheOrt"/> <label for="sucheVorname">Ansprechperson: </label><input type="text" value="" name="sucheVorname"/><input type="text" value="" name="sucheNachname"/> <select name="verkaeufer" size="1" id="verkaeufer" > <option value="0">Verkäufer</option> <?php $sql = "SELECT id_Benutzer, nachname FROM tbl_benutzerdaten ORDER BY nachname ASC"; $result = mysql_query($sql) or die("ERROR: ".mysql_error()); while($data = mysql_fetch_array($result)){ echo '<option value="'.$data['id_Benutzer'].'">'.$data['nachname'].'</option>'; } ?> </select> <input type="submit" value="SUCHE" name="s"/> </form> </td> <td align="right"> </td> </tr> </tbody> </table> <table border="0" cellpadding="0" cellspacing="0"> <colgroup> <col width="30" /> <col width="200" /> <col width="200" /> <col width="200" /> <col width="50" /> <col width="100" /> <col width="100" /> </colgroup> <thead> <tr> <th scope="col"></th> <th scope="col">Firma</th> <th scope="col">Ansprechperson</th> <th scope="col">Adresse</th> <th scope="col">PLZ</th> <th scope="col">Ort</th> <th scope="col">Telnr</th> </tr> </thead> <?php if($suche){ if($suche=='ALLE'){ $where=''; // ALLE DATENSÄTZE ANZEIGEN } elseif($suche=='0-9' || preg_match('/^[a-zA-Z]$/', $suche)){ $suche=strtoupper($suche); $where=" WHERE Firma REGEXP '^[" . mysql_real_escape_string($suche) . "]'"; // DATENSÄTZE DIE MIT BUCHSTABE ODER ZAHL AUS $suche BEGINNEN } else{ $where=" WHERE Firma LIKE '%" . mysql_real_escape_string($_POST['sucheFirma']) . "%' AND faStrasse LIKE '%" . mysql_real_escape_string($_POST['sucheStrasse']) . "%' AND faPLZ LIKE '%" . mysql_real_escape_string($_POST['suchePLZ']) . "%' AND faOrt LIKE '%" . mysql_real_escape_string($_POST['sucheOrt']) . "%' AND faVorname LIKE '%" . mysql_real_escape_string($_POST['sucheVorname']) . "%' AND faNachname LIKE '%" . mysql_real_escape_string($_POST['sucheNachname']) . "%' "; if($_POST['verkaeufer']>0) { $where.= "AND fid_benutzer=".$_POST['verkaeufer'];} } // GESAMTANZAHL ERMITTELN $sql = "SELECT COUNT(idFirma) FROM tbl_firmen" . $where; $result = mysql_query($sql) or die("ERROR: ".mysql_error()); $anzahl = mysql_result($result, 0); // GESAMTANZAHL ERMITTELN ENDE if ($anzahl==0){ echo 'Leider verlief die Suche ohne Erfolg!'; } else{ if ($anzahl==1){ echo '1 Eintrag gefunden'; } else{ echo '' . $anzahl . ' Einträge gefunden'; } $sql = "SELECT * FROM tbl_firmen" . $where . " ORDER BY Firma LIMIT " . $start . ", " . $ZeilenProSeite; $result = mysql_query($sql) or die("ERROR: ".mysql_error()); if(mysql_num_rows($result)>=1){ echo '<tbody>'; $nr=1; while($row = mysql_fetch_object($result)){ if($nr % 2 == 0 ){ $wert = 'bgFarbe1'; } else{ $wert = 'bgFarbe2'; } echo ' <form name="frmAnzeige" id="frmAnzeige" method="GET" action="fa_details.php"> <tr class="'.$wert.'"> <td align="center">'.($nr+$start).'</td> <input type="hidden" name="idFirma" value="'.$row->idFirma.'" /> <td><a href="' . $_SERVER['PHP_SELF'] . '?page=fa_details&id='.$row->idFirma.'">'.$row->Firma.'</a></td> <td>'.$row->faVorname.' '.$row->faNachname.'</td> <td>'.$row->faStrasse.' '.$row->faHausnr.'</td> <td>'.$row->faPLZ.'</td> <td>'.$row->faOrt.'</td> <td>'.$row->faTelVW.' '.$row->faTelNR.'</td> </tr> </form> '; $nr++; } echo '</tbody>'; } else{ echo 'Seite ' . $seite . ' existiert nicht!'; } // SEITEN BLAETTERN AUSGEBEN $gesamtseiten=ceil($anzahl/$ZeilenProSeite); echo 'Seite '; for($i=1;$i<=$gesamtseiten;$i++){ if($i==$seite){ echo '[' . $i . ']'; } else{ echo '[<a href="' . $_SERVER['PHP_SELF'] . '?page=firmen&seite=' . $i . '&s=' . $suche . '">' . $i . '</a>]'; } } echo ''; // SEITEN BLAETTERN AUSGEBEN } } else{ echo 'Bitte geben Sie einen Suchbegriff ein!'; } ?> </tbody> </table> </div> [/php] [/QUOTE]

Bilder bitte hier hochladen und danach über das Bild-Icon (Direktlink vorher kopieren) platzieren.

Authentifizierung

Wenn ▲ = 5, ▼ = 2 und ■ = 7, was ist ▲ × ▼ + ■?