How to use display sum() in codeigniter

Question

Mysql Query :

SELECT SUM(`Item_qty`), `bill_id`,`Item_name`,`table_id`,`Item_price` 
FROM tbl_billmenu 
WHERE `table_id` = 30 
GROUP BY `Item_name`

How should I've to code/implement this above query in codeigniter module ? please help

Possible duplicate of Get the result of SUM and group field from Active record in Codeigniter — H45H
– H45H, Commented Mar 14, 2019 at 10:05
This query is invalid GROUP BY .. I advice you to provide example data and expected results see Why should I provide an MCVE for what seems to me to be a very simple SQL query? — Raymond Nijland
– Raymond Nijland, Commented Mar 14, 2019 at 11:50

Saurabh · Accepted Answer · 2019-03-14 10:10:44Z

1

This is how you do it:

 $this->db->select(bill_id,Item_name,table_id,Item_price,sum(Item_qty) as quantity);
    $this->db->where('table_id', 30);
    $query = $this->db->get('tbl_billmenu');

answered Mar 14, 2019 at 10:10

Saurabh

4621 gold badge10 silver badges24 bronze badges

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

1 Comment

Raymond Nijland Over a year ago

@Swap This query is invalid GROUP BY you can't mix a non aggregate columns with a aggregate column.

Collectives™ on Stack Overflow

How to use display sum() in codeigniter

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related