db->like('promotionDate',$year,"BOTH")->where('rankId', $rankId)->get('officerRanks')->result() as $all){ if($this->session->userdata('role') == 'admin'){ $getDetails = $this->db->where('id',$all->userId)->get("personalDetails"); }elseif($this->session->userdata('role') == 'command'){ $getDetails = $this->db->where('id',$all->userId)->where('commandId', $this->session->userdata('commandId'))->get("personalDetails"); }elseif($this->session->userdata('role') == 'brigade'){ $getDetails = $this->db->where('id',$all->userId)->where('brigadeId', $this->session->userdata('brigadeId'))->get("personalDetails"); }elseif($this->session->userdata('role') == 'unit'){ $getDetails = $this->db->where('id',$all->userId)->where('unit', $this->session->userdata('unitId'))->get("personalDetails"); } foreach($getDetails->result() as $allOfficer){ $i++; ?>

S/No	Unique Number	Name	Gender	Unit
	uniqueNumber;?>	firstName.' '.$allOfficer->middleName.' '.$allOfficer->lastName);?>	gender);?>	Login_model->getUnit($allOfficer->unit);?>