Odd. I made a change that should have fixed the code, but it actually came up with LESS miles! Hmmm. Who knows PHP?
OLD
Code:
$getmiles = mysql_query("SELECT SUM(sumdistance) AS total FROM car");
$miles = mysql_fetch_array($getmiles);
NEW
Code:
$getmiles = mysql_query("SELECT SUM(sumdistance) AS total FROM car WHERE lmpgoverride != 0");
$carmiles = mysql_fetch_array($getmiles);
$getmoremiles = mysql_query("SELECT SUM(distance) AS total FROM data");
$datamiles = mysql_fetch_array($getmoremiles);
$miles = $carmiles['total'] + $datamiles['total'];