fhiiqm/form/rag_gv_search_form.inc.php
changeset 31 0a1eb975fbd9
parent 29 72f79dab938e
--- a/fhiiqm/form/rag_gv_search_form.inc.php	Fri Aug 31 14:22:20 2012 +0200
+++ b/fhiiqm/form/rag_gv_search_form.inc.php	Fri Nov 16 10:39:25 2012 +0100
@@ -27,7 +27,7 @@
             <?php 
                 if ($rag["abt"] == -1) $select = " selected "; else $select = "";
                 echo "<option $select value=\"-1\"></option>\n";
-                $sql = "SELECT abt_name, abt_long FROM Abteilung ORDER BY 1";
+                $sql = "SELECT abt_name, abt_long FROM Abteilung WHERE abt_ID < 8 ORDER BY abt_ID";
                 if ($result = $dbc->queryObjectArray($sql))
                 {
                     foreach ($result as $row)