help writing query

[CyberShot]

I have a database that I made that keeps track of my gas receipts. I already have one query going

$result = $myconn->query("SELECT * FROM stats ORDER BY date ASC");

while($row = mysqli_fetch_assoc($result)){
    $date = str_replace('-','/', $row['date']);

	echo "<tr><td id='". $row['id'] . "'>" . $row['miles'] . '</td><td>' . '$' . number_format($row['amount'], 2) . 
	'</td><td> ' . $row['gallons'] . '</td><td> ' . $date . "</td></tr>";
}

I want to add two other query's to add up all the amounts that are in the amount column and all the gallons in the gallons column. So I made this query that gets the amount but I have no idea how to add up the gallons without making another query and loop.

$result = $myconn->query('SELECT SUM(amount) as total FROM stats');
		
	while($row = mysqli_fetch_assoc($result)){
	$sum = $row['total'];
}
echo $sum;

[CyberShot]

Solved it

$result = $myconn->query('SELECT SUM(amount) as total, SUM(gallons) as gallons FROM stats');

Edited November 26, 2015 by CyberShot