fhiiqm/raum_vma_ed.php
changeset 39 4ce411ed28b6
parent 38 45c139f74ea4
child 40 6f4b105daa24
--- a/fhiiqm/raum_vma_ed.php	Mon Jul 01 14:36:18 2013 +0200
+++ b/fhiiqm/raum_vma_ed.php	Wed Jul 31 15:10:48 2013 +0200
@@ -190,7 +190,7 @@
                     $select = null;
                     $select = ( "-1"==$ap['gf'][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";