Easy ActiveRecord questions

[eluser]Armchair Samurai[/eluser]
Use aliases and always be specific which columns you are calling. For example

Code:

$this->db->select('u.foo, c.foo AS collection_foo');
$this->db->join('collection c', 'u.collection_id = c.collection.id');
$this->db->where('u.user_id', $user_id);
$query = $this->db->get('user_access u');