How to use Codeigniter Select with sum if?

Question

What I want to do is use sum if in codeigniter, it's got error when I run in browser, but I query in MYSQL, there are not error and working nicely.

Here is my code

$this->db->select('sum(if(`monitoring_type` = 1,1,0)) AS independent,sum(if(`monitoring_type` = 2,1,0)) AS buddy,count(*) AS TM, rate_info.qm_title');
$this->db->from('qm.recordings');
$this->db->join('qm.rate_info', 'recordings.record_id = rate_info.record_id');
$query = $this->db->get();
return $query->result();

my Error enter image description here

MYSQL

enter image description here

Prabhukiran · Accepted Answer · 2013-08-14 06:20:06Z

5

Add FALSE as the second parameter to

$this->db->select('your Query', FALSE);

Update:

It removes the escape identifiers (the backticks) from the select statement which codeigniter does by default for each query. So

SELECT `column1`, `column2` FROM table

will become

SELECT column1, column2 FROM table

edited Aug 14, 2013 at 6:20

answered Aug 14, 2013 at 5:50

Prabhukiran

1491 silver badge8 bronze badges

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

1 Comment

Eswara Reddy Over a year ago

@Prabhukiran can you explain me why FALSE is required?

Collectives™ on Stack Overflow

How to use Codeigniter Select with sum if?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related