IF statement in an MySQL query

IF statement in an MySQL query

01-21-2014, 10:41 AM

[eluser]CroNiX[/eluser]
You didn't show the full line for the db: Confused

elect(), but try setting the 2nd parameter of db: Confused

elect() to FALSE.

Code:
$this->db->select(the_query, FALSE);

which will prevent it from escaping the identifiers by adding tickmarks, "`"

Messages In This Thread

IF statement in an MySQL query - by El Forum - 11-05-2009, 02:08 PM

IF statement in an MySQL query - by El Forum - 11-05-2009, 02:31 PM

IF statement in an MySQL query - by El Forum - 11-05-2009, 05:01 PM

IF statement in an MySQL query - by El Forum - 11-05-2009, 05:06 PM

IF statement in an MySQL query - by El Forum - 11-05-2009, 05:09 PM

IF statement in an MySQL query - by El Forum - 11-05-2009, 05:17 PM

IF statement in an MySQL query - by El Forum - 01-21-2014, 02:40 AM

IF statement in an MySQL query - by El Forum - 01-21-2014, 10:41 AM

IF statement in an MySQL query - by El Forum - 01-21-2014, 12:44 PM

IF statement in an MySQL query - by El Forum - 01-21-2014, 12:51 PM

IF statement in an MySQL query - by El Forum - 01-21-2014, 01:00 PM

IF statement in an MySQL query - by El Forum - 01-21-2014, 01:08 PM

IF statement in an MySQL query - by El Forum - 01-21-2014, 01:16 PM