How to display SQL Sum query in html?

[mal14]

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:'

Edited April 1, 2017 by mal14

[emptry]

is the coloum int ?

 

With html ? ..

I would use php and echo/print it

Edited April 1, 2017 by emptry

[mal14]

is the coloum int ?

No, it's float :/

[mal14]

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

[Jacques1]

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”.

[mal14]

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