CodeIgniter active record, Add IF statement in ->select() function

Question

I have this query:

$this->db->select("
    IF(predicts.predict_owner = votes.vote_user_id , IF(judges.judge_did_accept = 1 , True , False) , 'NotExists' )" , 'user_judgement');

I get syntax error on

  `'NotExists'` )

If I run the query directly inside the database, it works fine...
Is there any way to prevent CI to add the sign ` automatically?

Thanks

What are you passing there as a second parameter?

Joseph Silber
– Joseph Silber

2011-08-19 16:19:55 +00:00
Commented Aug 19, 2011 at 16:19 — Joseph Silber
– Joseph Silber, Commented Aug 19, 2011 at 16:19

Alfonso Rubalcava · Accepted Answer · 2011-08-19 22:26:18Z

21

You can call the select method with FALSE as the last parameter, like this

$this->db->select("IF(predicts.predict_owner = votes.vote_user_id , IF(judges.judge_did_accept = 1 , True , False) , 'NotExists' ),'user_judgement'",false);

That will prevent CI to add the `

From User Guide

$this->db->select() accepts an optional second parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks. This is useful if you need a compound select statement.

PS: I see you call select with the second param as "user_judgement", I'm not sure what that should be doing, it's not the cay CI wants you to use Active Record

edited Aug 19, 2011 at 22:26

Alfonso Rubalcava

2,24717 silver badges27 bronze badges

answered Aug 19, 2011 at 16:25

Dan F.

1,37316 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

CodeIgniter active record, Add IF statement in ->select() function

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related