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

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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.