fhiiqm/form/raumarbgr_form.inc.php
changeset 39 4ce411ed28b6
parent 34 fc60ef80a7ad
child 42 cfc409017ba8
--- a/fhiiqm/form/raumarbgr_form.inc.php	Mon Jul 01 14:36:18 2013 +0200
+++ b/fhiiqm/form/raumarbgr_form.inc.php	Wed Jul 31 15:10:48 2013 +0200
@@ -107,7 +107,7 @@
                 $select = null;
                 $select = ( "-1"==$rag['ma'][0] ) ? ' selected' : null;
                 echo "<option $select value=\"-1\"></option>\n";
-                $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') AS ma
+                $sql = "SELECT persknr, CONCAT (nachname, ', ',IFNULL(vorname,''), ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') AS ma
                  FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID WHERE aktiv < 2 ORDER BY 2";
                 if ($result = $dbc->queryObjectArray($sql))
                 {