Simple query left join question - MVC

[eluser]techgnome[/eluser]
I handled my similar situation in the model as part of my select statement:

Code:

$this->db->select("CASE WHEN ifnull(historylist.picture, '') = '' THEN 'na_01.jpg' ELSE historylist.picture END albumcover");

I did it like this, because it's part of the data logic as far as I am concerned. Neither the controller nor the view should care what the picture is... I did my best to keep the controllers fairly stupid and the views even dumber.

Not saying it's the best way or only way... just pointing out an alternative.

-tg