Need Help for sum statement

[eluser]Farzand[/eluser]
$this->db->select(“bt_tayyab_lc.id as id, sum(bt_tayyab_lc.weight) as weight,bt_tayyab_remarks.id as id, bt_tayyab_remarks.lcid as lcid”);
$this->db->join(‘tayyab_remarks’,‘tayyab_lc.id = tayyab_remarks.lcid’ ,‘left’);
$this->db->where(‘tayyab_lc.creat_at >=’, $currentdate1);
$this->db->where(‘tayyab_lc.creat_at <=’, $currentdate);
$this->db->where(‘tayyab_lc.cid’,‘1’);
$data[‘supplier_account’] = $this->db->get(‘tayyab_lc’);