[eluser]li9ht[/eluser]
ive been using lots of query to do this
Code:
$sql5=$this->db->select_sum('total','total');
$sql5=$this->db->where('date',"2008-11-22");
$d22=$this->db->get('sale',$sql5);
$data['d22']=$d22->row();
$sql6=$this->db->select_sum('total','total');
$sql6=$this->db->where('date',"2008-11-23");
$d23=$this->db->get('sale',$sql6);
$data['d23']=$d23->row();
$sql7=$this->db->select_sum('total','total');
$sql7=$this->db->where('date',"2008-11-29");
$d29=$this->db->get('sale',$sql7);
$data['d29']=$d29->row();
$sql8=$this->db->select_sum('total','total');
$sql8=$this->db->where('date',"2008-11-30");
$d30=$this->db->get('sale',$sql8);
$data['d30']=$d30->row();
$sql9=$this->db->select_sum('total','total');
$sql9=$this->db->where('date',"2008-12-06");
$d06=$this->db->get('sale',$sql9);
$data['d06']=$d06->row();
$sql10=$this->db->select_sum('total','total');
$sql10=$this->db->where('date',"2008-12-07");
$d07=$this->db->get('sale',$sql10);
$data['d07']=$d07->row();
the only thing changing is the date. can i create a function and just send the date to the function/class and insert in my index function .. how do it do it.?