CyberShot Posted November 26, 2015 Share Posted November 26, 2015 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; Quote Link to comment https://forums.phpfreaks.com/topic/299584-help-writing-query/ Share on other sites More sharing options...
Solution CyberShot Posted November 26, 2015 Author Solution Share Posted November 26, 2015 (edited) Solved it $result = $myconn->query('SELECT SUM(amount) as total, SUM(gallons) as gallons FROM stats'); Edited November 26, 2015 by CyberShot Quote Link to comment https://forums.phpfreaks.com/topic/299584-help-writing-query/#findComment-1527191 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.