Welcome Guest, Not a member yet? Register   Sign In
how to create funciton or class or???
#1

[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.?


Messages In This Thread
how to create funciton or class or??? - by El Forum - 12-02-2008, 10:50 PM
how to create funciton or class or??? - by El Forum - 12-02-2008, 11:04 PM
how to create funciton or class or??? - by El Forum - 12-02-2008, 11:56 PM



Theme © iAndrew 2016 - Forum software by © MyBB