if ( @mysql_connect('localhost', 'rex', 'dairyfarm') ){ mysql_select_db('rex'); $res = mysql_query("select date_format(filledup,'%m/%d/%Y'), mileage,ppg,gallons from mileage order by mileage"); echo "
\n"; ?>
date
odometer
price
gallons
miles/gallon
while ( list($date,$mileage, $ppg, $gallons) = mysql_fetch_row($res) ) { echo "
"; echo "
$date
"; echo "
$mileage
"; echo "
$ppg
"; echo "
$gallons
"; if ( $lastmiles ) { echo "
"; echo round((($mileage - $lastmiles) / $gallons),2); echo "
"; } else { echo "
"; } $lastmiles = $mileage; echo "
\n"; } echo "
\n"; } else { ?> MYSQL CONNECTION FAILED! } ?>