db->join("table", "column = " . $int) ... uses backticks and gives an error!

db->join("table", "column = " . $int) ... uses backticks and gives an error!

El Forum
Guest

09-18-2009, 05:01 PM

[eluser]pmhart[/eluser]
I am trying to do the following:

$this->db->join("tab as t", "t.id = " . $tab_id);

And I get an error that says:

Unknown column '25501' in 'on clause'

Given the $tab_id=25501, CI creates a query like this

JOIN `tab` as t ON `t`.`id` = `25501`

I need that number to not have backticks! I can do it as a valid query manually in mySQL, any suggestions?

Messages In This Thread

db->join("table", "column = " . $int) ... uses backticks and gives an error! - by El Forum - 09-18-2009, 05:01 PM

db->join("table", "column = " . $int) ... uses backticks and gives an error! - by El Forum - 09-21-2009, 10:53 AM

db->join("table", "column = " . $int) ... uses backticks and gives an error! - by El Forum - 09-21-2009, 01:09 PM

db->join("table", "column = " . $int) ... uses backticks and gives an error! - by El Forum - 09-28-2009, 02:41 PM

db->join("table", "column = " . $int) ... uses backticks and gives an error! - by El Forum - 09-28-2009, 02:52 PM

db->join("table", "column = " . $int) ... uses backticks and gives an error! - by El Forum - 09-28-2009, 03:45 PM

db->join("table", "column = " . $int) ... uses backticks and gives an error! - by El Forum - 09-28-2009, 06:21 PM

db->join("table", "column = " . $int) ... uses backticks and gives an error! - by El Forum - 09-29-2009, 08:00 AM