View Single Post
  #17 (permalink)  
Old 09-08-2004, 03:42 PM
Jason Jason is offline
GreenHybrid Founder
 
Real Name: Jason Siegel
Location: Houston, TX
Hybrids: 2004 Toyota Prius
Posts: 4,596
Default

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++;

}

.

Read my new biweekly column, The Western Street 7.
Visit my political debate forum, Volconvo.
Reply With Quote