mal14 Posted April 1, 2017 Share Posted April 1, 2017 I've come up with an SQL sum query: $query = "SELECT SUM(calories) FROM tracklog AS calories WHERE userid = $_SESSION[userid]"; No errors are shown, however how do I get this value to be displayed using HTML? I want it to be displayed after 'Total number of calories lost to date:' Link to comment Share on other sites More sharing options...
emptry Posted April 1, 2017 Share Posted April 1, 2017 is the coloum int ? With html ? ..I would use php and echo/print it Link to comment Share on other sites More sharing options...
mal14 Posted April 1, 2017 Author Share Posted April 1, 2017 is the coloum int ? No, it's float :/ Link to comment Share on other sites More sharing options...
mal14 Posted April 1, 2017 Author Share Posted April 1, 2017 is the coloum int ? With html ? .. I would use php and echo/print it I tried doing this! while($row = mysqli_fetch_assoc($result)) { echo 'Calories burned to date: '.$row['calories']; } However, I keep getting any error saying calories is an undefined index Link to comment Share on other sites More sharing options...
Jacques1 Posted April 1, 2017 Share Posted April 1, 2017 Yes, because there is no “calories” column in your result set. The only column is “SUM(calories)”. To get a more handy name, use an alias: SELECT SUM(calories) AS total_calories FROM ...; Then the column is called “total_calories”. Link to comment Share on other sites More sharing options...
mal14 Posted April 1, 2017 Author Share Posted April 1, 2017 Yes, because there is no “calories” column in your result set. The only column is “SUM(calories)”. To get a more handy name, use an alias: SELECT SUM(calories) AS total_calories FROM ...; Then the column is called “total_calories”. Thank you!!! It works Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.