72 echo "<p><br /><br /> <a href=/fhiiqm/test/ma_tel_flist_mysql.php>« zur Telefon-Liste</a></p>\n"; |
72 echo "<p><br /><br /> <a href=/fhiiqm/test/ma_tel_flist_mysql.php>« zur Telefon-Liste</a></p>\n"; |
73 echo "</body></html>\n"; |
73 echo "</body></html>\n"; |
74 } |
74 } |
75 else |
75 else |
76 { |
76 { |
77 $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 "; |
77 $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 "; |
78 |
78 |
79 if ($sort == '2') $sort = "2,3,12,5,6"; |
79 if ($sort == '2') $sort = "2,3,12,5,6"; |
80 elseif ($sort == '12') $sort = "12,5,2,3,6"; |
80 elseif ($sort == '12') $sort = "12,5,2,3,6"; |
81 else $sort = "2,3,12,5,6"; |
81 else $sort = "2,3,12,5,6"; |
82 |
82 |
83 if ($abt > '-1') $wher = " WHERE abt_tel = $abt "; else $wher = ""; |
83 if ($abt > '-1') $wher = " AND abt_tel = $abt "; else $wher = ""; |
84 |
84 |
85 $sql .= $wher . " ORDER BY $sort"; |
85 $sql .= $wher . " ORDER BY $sort"; |
86 $result=mysql_query($sql,$conn); |
86 $result=mysql_query($sql,$conn); |
87 if ($result && mysql_num_rows($result)) |
87 if ($result && mysql_num_rows($result)) |
88 { |
88 { |