--- a/fhiiqm/test/ma_tel_pdf_mysql.php	Fri Dec 21 15:31:50 2012 +0100
+++ b/fhiiqm/test/ma_tel_pdf_mysql.php	Wed Feb 27 09:43:08 2013 +0100
@@ -74,13 +74,13 @@
     }
     else
     {
-        $sql = "SELECT persknr, name, vorname, titel, abt_name, telefon_nr, telefon_typ, public, geb_ID, raum_nr, email, abt_tel+0 FROM v_tel_list "; 
+        $sql = "SELECT persknr, name, vorname, titel, abt_name, telefon_nr, telefon_typ, public, geb_ID, raum_nr, email, abt_tel+0 FROM v_tel_list WHERE public=1 "; 
     
         if ($sort == '2') $sort = "2,3,12,5,6";
         elseif ($sort == '12') $sort = "12,5,2,3,6";
         else $sort = "2,3,12,5,6";
         
-        if ($abt > '-1') $wher = " WHERE abt_tel = $abt "; else $wher = "";
+        if ($abt > '-1') $wher = " AND abt_tel = $abt "; else $wher = "";
         
         $sql .= $wher . " ORDER BY $sort";
         $result=mysql_query($sql,$conn);