fhiiqm/keytyp_ma_search.php
changeset 44 d652bbba2d43
parent 41 9c668cd391fa
--- a/fhiiqm/keytyp_ma_search.php	Wed Aug 06 09:42:40 2014 +0200
+++ b/fhiiqm/keytyp_ma_search.php	Fri Feb 05 14:03:40 2016 +0100
@@ -143,7 +143,7 @@
         else
         {
             $sql = "SELECT km.keytyp_ID, key_level, pers_anz AS anzahl,pers_date, pers_bem, depot_ID, 
-                    CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') AS nvname,  
+                    CONCAT (nachname, IFNULL(CONCAT(', ',vorname),''), ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') AS nvname,  
                 	(CASE WHEN pers_action = 'get' THEN 'erhalten' WHEN  pers_action = 'out' THEN 'zurück' ELSE 'verloren'  END) AS status
                 	FROM fhiiqm.Mitarbeiter m 
                 	INNER JOIN Keytyp_MA km ON m.persknr=km.persknr