Here's what I ran through to update all the cars:
Code:
$cid = 0;
while ($cid <= 359) {
$weightSQL = "SELECT mileage,distance,temperature,time,highway,traffic FROM data WHERE cid = '$cid'";
$weightresult = mysql_query($weightSQL) or die(mysql_error());
while ( $weight = mysql_fetch_array($weightresult) ) {
if ($weight['mileage'] != 0) { $mileagedenominator = $mileagedenominator + $weight['distance']/$weight['mileage']; }
if ($weight['temperature'] != 0) { $temperaturedenominator = $temperaturedenominator + $weight['distance']/$weight['temperature']; }
if ($weight['time'] != 0) { $timedenominator = $timedenominator + $weight['distance']/$weight['time']; }
if ($weight['highway'] != 0) { $highwaydenominator = $highwaydenominator + $weight['distance']/$weight['highway']; }
if ($weight['traffic'] != 0) { $trafficdenominator = $trafficdenominator + $weight['distance']/$weight['traffic']; }
$numerator= $numerator + $weight['distance'];
if ($mileagedenominator != 0) { $mileage = $numerator / $mileagedenominator; }
if ($temperaturedenominator != 0) { $temperature = round($numerator / $temperaturedenominator,0); }
if ($timedenominator != 0) { $time = round($numerator / $timedenominator,0); }
if ($highwaydenominator != 0) { $highway = $numerator / $highwaydenominator; }
if ($trafficdenominator != 0) { $traffic = $numerator / $trafficdenominator; }
if ($override['lmpgoverride'] != 0) {
$mileage = $override['lmpgoverride'];
}
}
$updateSQL = "UPDATE car SET avgmileage = '$mileage', avgtemperature = '$temperature', avgtime = '$time', avghighway = '$highway', avgtraffic = '$traffic' WHERE cid = '$cid'";
mysql_query($updateSQL) or die(mysql_error());
echo "$cid<br>";
$cid++;
}