what's wrong with my sum query in model php codeigniter? [duplicate]

Question

here's my model code :

function total($id)
    {
        $this->db->select_sum('score');
        $q = $this->db->get('my_table');
        $this->db->where('id',$id);
        $this->db->group_by('id');
        return $q->row()->score;  

    }

why the output still sum all of row not the specific row with id?

gen_Eric · Accepted Answer · 2015-09-02 14:25:47Z

3

$this->db->get() actually runs the query. You need to call that last.

function total($id)
    {
        $this->db->select_sum('score');
        $this->db->where('id',$id);
        $this->db->group_by('id');

        $q = $this->db->get('my_table');
        return $q->row()->score;  

    }

answered Sep 2, 2015 at 14:25

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

what's wrong with my sum query in model php codeigniter? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related