diff -r 3ebe66308a00 -r f990704af47b fhiiqm/inc/ma_list_ac.inc.php --- a/fhiiqm/inc/ma_list_ac.inc.php Fri Oct 14 15:37:47 2011 +0200 +++ b/fhiiqm/inc/ma_list_ac.inc.php Fri Nov 04 11:18:11 2011 +0100 @@ -15,8 +15,9 @@ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); $dbc = new dbconnection(); - - $sql = "SELECT CONCAT (nachname, ', ',vorname) as label, CONCAT (nachname, ', ',vorname) as val,persknr as id + // label = angezeigter ListenWert, val = Wert im Eingabefeld nach Klick + $sql = "SELECT CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'ehemals' END, ')') as label, + CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'ehemals' END, ')') as val,persknr as id FROM fhiiqm.Mitarbeiter WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci ORDER BY 1";