session->userdata('role') == 'admin'){ $get = $this->db->get("usersUnit"); }elseif($this->session->userdata('role') == 'command'){ $get = $this->db->where('commandId', $this->session->userdata('commandId'))->get("usersUnit"); }elseif($this->session->userdata('role') == 'brigade'){ $get = $this->db->where('brigadeId', $this->session->userdata('brigadeId'))->get("usersUnit"); } foreach($get->result() as $details){ foreach($this->db->where('id',$details->unitId)->get('militaryUnits')->result() as $unit){ $unitName = $unit->name; } foreach($this->db->where('id',$details->brigadeId)->get('brigades')->result() as $brigade){ $brigadeName = $brigade->name; } foreach($this->db->where('id',$details->commandId)->get('commands')->result() as $command){ $commandName = $command->name; } ?>

Name	Email [Username]	Unit	Brigade	Command	Status
fullName);?>	email;?>				status==0){?> Active Disable Disabled Enable