从控制器获取和值以查看

Question

这里是我的控制器功能

function assignPartner($id){ 

    $data['projects']=$this->admin_model->getProfData($id,'id','project')->result(); 
    $data['partners']=$this->admin_model->getTableData('partner')->result(); 
    $data['budge']=$this->db->query('SELECT SUM(amount) FROM budge WHERE project_id="'.$id.'"')->result(); 
    //print_r($data);exit; 
    $this->load->view('projectheader',$data); 
    $this->load->view('assignpartner',$data); 
    $this->load->view('projectfooter'); 

} 

这是我的看法页

<?php echo $budge[0]->amount;?> 

Answer 1

您需要别名的总和。如果你的var_dump $在您的视图让步，你会看到实际的名字 - 应该是搞砸这样的：

$budge[0]->SUM(amount). 

更改SQL来..

SELECT SUM(amount) AS amount FROM budge WHERE project_id=