--- a/fhiiqm/test/ma_tel_flist_mysql.php	Fri Dec 21 15:31:50 2012 +0100
+++ b/fhiiqm/test/ma_tel_flist_mysql.php	Wed Feb 27 09:43:08 2013 +0100
@@ -115,8 +115,15 @@
 
     if (mysql_errno())
     	echo "error after connect und db select: " . mysql_errno() . ": " . mysql_error() . "<br>\n";
-    $sql = "SELECT persknr, name, vorname, titel, abt_name, telefon_nr, telefon_typ, public, geb_ID, raum_nr, email FROM v_tel_list";
-    if ($filter) $wher = " WHERE " . $fieldf[$fnum] . " LIKE " . "'%$filter%'"; else $wher = "";
+    $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";
+    if ($filter)
+    {
+        if ($fnum > 3)
+            $wher = " AND " . $fieldf[$fnum] . " LIKE " . "'%$filter%'"; 
+        else
+            $wher = " AND " . $fieldf[$fnum] . " LIKE " . "'$filter%'"; 
+    }
+    else $wher = ""; 
     if ($sort == 2) $sort = "2, 3, 5";
     if ($sort == 5) $sort = "5, 2, 3";
     if ($sort) $ord = " ORDER BY $sort, 6"; // immer nach Telefon-Nr als 2.
@@ -173,6 +180,13 @@
                 echo "</form>\n";
                 echo "<p>&nbsp;&nbsp;&nbsp;</p>\n";
             }
+        // Schnellsuche Namen
+        echo "<p>";
+        for ($j=65; $j<91; $j++)
+        {
+            echo "<a href='". $_SERVER["PHP_SELF"] . "?f=2&b=". chr($j)."' target=\"_self\" title=\"Telefonliste\" class=\"sc\"><b>".chr($j)."</b>&nbsp;&nbsp;&nbsp;</a>"; 
+        }
+        echo "</p>\n";
             echo "<table width='70%'>\n";
             
             if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td></tr>\n";