Reputation: 167
I have following code:
$m1 = $this->dbop->customquery('SELECT DISTINCT number FROM users');
$message =''; $email='';
$count=array();
foreach($m1 as $item){
$message='';
$count=array();
$m2 = $this->dbop->customquery("SELECT * FROM users where
number='".$item->number."'");
foreach ($m2 as $value) {
//$data['alldata'] = $value;
$count[] = $this->dbop->customquery("SELECT * FROM
s_data where userid='".$value->id."'");
$os_count = $this->dbop->customquery("SELECT * FROM
os where userid='".$value->id."'");
$data['dd']=$this->dbop->customquery("SELECT * FROM os
where userid='".$value->id."'");
}
}
$data['username'] = $this->session->userdata('username');
$this->load->view('header-inside', $data);
$this->load->view('am-report' , $data);
$this->load->view('crm/footer-inside');
I want to pass the $data['dd]
to view.
What currently I am receving is only first value.
Help me for this
Upvotes: 0
Views: 233
Reputation: 1200
You are replacing $data['dd'] value. every time foreach loop runs it will replace with new value. Instead do like this
$data['dd'][] = $this->dbop->customquery("SELECT * FROM os
where userid='".$value->id."'");
Upvotes: 1