$form->field('chairman_id')->set_options(\DB::select('id', array(\DB::expr('CONCAT(surname,", ",initials," ",prefix)'), 'name'))->from('people')->where('type', '=', 'E')->order_by('name', 'ASC')->execute()->as_array('id', 'name'));
It looks like you're new here. If you want to get involved, click one of these buttons!