fhiiqm/report/abt_ag_aptyp_report.php
changeset 31 0a1eb975fbd9
parent 29 72f79dab938e
child 41 9c668cd391fa
equal deleted inserted replaced
30:d02d02efc55a 31:0a1eb975fbd9
    98                 <td>
    98                 <td>
    99                     <select name="rag[abt]" size="1">
    99                     <select name="rag[abt]" size="1">
   100                     <?php 
   100                     <?php 
   101                         if ($rag["abt"] == -1) $select = " selected "; else $select = "";
   101                         if ($rag["abt"] == -1) $select = " selected "; else $select = "";
   102                         echo "<option $select value=\"-1\"></option>\n";
   102                         echo "<option $select value=\"-1\"></option>\n";
   103                         $sql = "SELECT abt_ID, abt_name, abt_long FROM Abteilung ORDER BY 1";
   103                         $sql = "SELECT abt_ID, abt_name, abt_long FROM Abteilung WHERE abt_ID < 8 ORDER BY 1";
   104                         if ($result = $dbc->queryObjectArray($sql))
   104                         if ($result = $dbc->queryObjectArray($sql))
   105                         {
   105                         {
   106                             foreach ($result as $row)
   106                             foreach ($result as $row)
   107                             {
   107                             {
   108                                 if ($row->abt_ID == $rag['abt'])
   108                                 if ($row->abt_ID == $rag['abt'])