fhiiqm/report/rag_gefahr_massn_report.php
changeset 31 0a1eb975fbd9
parent 29 72f79dab938e
child 33 f1a8785434e4
equal deleted inserted replaced
30:d02d02efc55a 31:0a1eb975fbd9
   109                 <td>
   109                 <td>
   110                     <select name="rag[abt]" size="1" onchange="this.form.submit();">
   110                     <select name="rag[abt]" size="1" onchange="this.form.submit();">
   111                     <?php 
   111                     <?php 
   112                         if ($rag["abt"] == -1) $select = " selected "; else $select = "";
   112                         if ($rag["abt"] == -1) $select = " selected "; else $select = "";
   113                         echo "<option $select value=\"-1\"></option>\n";
   113                         echo "<option $select value=\"-1\"></option>\n";
   114                         $sql = "SELECT abt_ID, abt_name, abt_long FROM Abteilung ORDER BY 1";
   114                         $sql = "SELECT abt_ID, abt_name, abt_long FROM Abteilung WHERE abt_ID < 8 ORDER BY 1";
   115                         if ($result = $dbc->queryObjectArray($sql))
   115                         if ($result = $dbc->queryObjectArray($sql))
   116                         {
   116                         {
   117                             foreach ($result as $row)
   117                             foreach ($result as $row)
   118                             {
   118                             {
   119                                 if ($row->abt_ID == $rag['abt'])
   119                                 if ($row->abt_ID == $rag['abt'])