Summation of PIREP Revenue

[Parkho]

Hi there,

I'm trying to get sum of revenue for a pilot's all PIREPS, so here is the function:

public static function totalrev($pilotid)
{
 $sql = 'SELECT pilotid, SUM(revenue) FROM '.TABLE_PREFIX.'pireps
 WHERE pilotid='.intval($pilotid).'
 GROUP by '.$pilotid ;

 return DB::get_results($sql);
}

And I have the following in my .tpl file:

$pilotid = Auth::$userinfo->pilotid ;
$row = PIREPData::totalrev($pilotid);
echo FinanceData::formatMoney($row);

And I get nothing. please help me find out where I'm wrong.

Thanks