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

[eluser]kurucu[/eluser]
It doesn't look like a valid query to me, because I can't see how it would differ from a Where clause, but I'm no expert. I'd have thought you need to specify another table and column.

Anyway. The answer, as usual, appears to lie in the documentation, which says that you can just pass a SQL string into the select function, specifying the last parameter as FALSE to stop CI including backticks for you. This means you'd have to stop using active record for that particular query as the query is somewhat non-standard.

If you got it working in mysql, it would be worth pasting the code here if you still have problems later.