Welcome Guest, Not a member yet? Register   Sign In
db->join("table", "column = " . $int) ... uses backticks and gives an error!

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.

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

Theme © iAndrew 2016 - Forum software by © MyBB