order by using db adapter query

[AndrewSimm]

I have done some var_dumps and the right string is being assigned to $sort. What am I doing wrong that is preventing this from working? The query itself works fine, it just doesn't return using the right order by.

PHP:

$sort = $this->filter('sort', 'str');

if(empty($sort))
{
    $sort = 'year';
}

$db = $this->app->db();
$recruitingYears = $db->fetchAll('
select
year.name as "year"
,sum(case when player.rating_star = 5 then 1 else 0 end) as five_star
,sum(case when player.rating_star = 4...

Read more