Newbie Q - controller/view code for mixed query

[eluser]srpurdy[/eluser]
I don't really understand the argument lol. They both work!

Personally I use AR mostly because the code looks much cleaner. In a big application things can get too messy in SQL. I like AR for that reason quite a lot.

I normally don't keep repeating $this->db over and over though.

More like something like

Code:

$my_query = $this->db
->where('if needed')
->select('columns here')
->from('table')
->join('if needed')
->limit('if needed')
->order_by('if needed')
->group_by('if needed')
->get();
return $my_query;

Can also stick a sub query in there too if needed. I just find this very clean to look at.

Just my 2 cents worth.