| changeset 34 | fc60ef80a7ad |
| parent 33 | f1a8785434e4 |
| 33:f1a8785434e4 | 34:fc60ef80a7ad |
|---|---|
113 |
113 |
114 $db=mysql_select_db($config["dbname"],$conn); // or die("Keine Verbindung zur DB fhiiqm"); |
114 $db=mysql_select_db($config["dbname"],$conn); // or die("Keine Verbindung zur DB fhiiqm"); |
115 |
115 |
116 if (mysql_errno()) |
116 if (mysql_errno()) |
117 echo "error after connect und db select: " . mysql_errno() . ": " . mysql_error() . "<br>\n"; |
117 echo "error after connect und db select: " . mysql_errno() . ": " . mysql_error() . "<br>\n"; |
118 $sql = "SELECT persknr, name, vorname, titel, abt_name, telefon_nr, telefon_typ, public, geb_ID, raum_nr, email FROM v_tel_list"; |
118 $sql = "SELECT persknr, name, vorname, titel, abt_name, telefon_nr, telefon_typ, public, geb_ID, raum_nr, email FROM v_tel_list WHERE public=1"; |
119 if ($filter) $wher = " WHERE " . $fieldf[$fnum] . " LIKE " . "'%$filter%'"; else $wher = ""; |
119 if ($filter) |
120 { |
|
121 if ($fnum > 3) |
|
122 $wher = " AND " . $fieldf[$fnum] . " LIKE " . "'%$filter%'"; |
|
123 else |
|
124 $wher = " AND " . $fieldf[$fnum] . " LIKE " . "'$filter%'"; |
|
125 } |
|
126 else $wher = ""; |
|
120 if ($sort == 2) $sort = "2, 3, 5"; |
127 if ($sort == 2) $sort = "2, 3, 5"; |
121 if ($sort == 5) $sort = "5, 2, 3"; |
128 if ($sort == 5) $sort = "5, 2, 3"; |
122 if ($sort) $ord = " ORDER BY $sort, 6"; // immer nach Telefon-Nr als 2. |
129 if ($sort) $ord = " ORDER BY $sort, 6"; // immer nach Telefon-Nr als 2. |
123 $sql .= $wher . $ord; |
130 $sql .= $wher . $ord; |
124 if ($conn && $db) |
131 if ($conn && $db) |
171 */ |
178 */ |
172 echo "<td><input class=\"button\" type=\"hidden\" value=\"finden\" name=\"subf\" title=\"subf\" /></td></tr></table>\n"; |
179 echo "<td><input class=\"button\" type=\"hidden\" value=\"finden\" name=\"subf\" title=\"subf\" /></td></tr></table>\n"; |
173 echo "</form>\n"; |
180 echo "</form>\n"; |
174 echo "<p> </p>\n"; |
181 echo "<p> </p>\n"; |
175 } |
182 } |
183 // Schnellsuche Namen |
|
184 echo "<p>"; |
|
185 for ($j=65; $j<91; $j++) |
|
186 { |
|
187 echo "<a href='". $_SERVER["PHP_SELF"] . "?f=2&b=". chr($j)."' target=\"_self\" title=\"Telefonliste\" class=\"sc\"><b>".chr($j)."</b> </a>"; |
|
188 } |
|
189 echo "</p>\n"; |
|
176 echo "<table width='70%'>\n"; |
190 echo "<table width='70%'>\n"; |
177 |
191 |
178 if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td></tr>\n"; |
192 if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td></tr>\n"; |
179 |
193 |
180 // Listenkopf generieren |
194 // Listenkopf generieren |