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-28-2009, 03:45 PM

[eluser]pmhart[/eluser]
Hmm, despite the "etiquette" of JOINs, it's valid to mySQL and does what I need.

I need to JOIN the "tab" table because it contains the submission ID. And tab attributes are sometimes referenced by a submission ID because the tab id was not added.

I can add tab to the FROM with a comma, but that query takes 8 seconds. Using a JOIN takes less than a split second.

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