Total Miles

[mark1million]

Is there a function to show a pilots total miles flown?

[Guest lorathon]

This should work for you. Or you can add the SUM(distance) AS distance to some other query.

$sql = 'SELECT 
       SUM(distance) AS distance
       FROM '.TABLE_PREFIX.'pireps
       WHERE `pilotid` = '.$pilotid
       ;

$info = DB::get_row($sql);

echo $info->distance;

[mark1million]

Cheers Jeff,

Had to use $userinfo->pilotid works great