How to compare two columns in a JOIN with CI

[eluser]zyzzzz[/eluser]
I believe ActiveRecord just makes things more difficult, I've stopped using it in my code.
Use something like this:

Code:

$sql = 'SELECT * FROM table WHERE something = ? AND somethingelse = ?';
$bindings = array($value_1, $value2);
$results = $this->db->query($sql, $bindings)->result_array();

You know exactly what the code is doing and using that bindings array will automagically make everything safe.