That worked well, although it's outputting to the nearest decimal but i need it to output to the nearest whole number. I created a new variable $total...
Here's what i got:
$total = sql::query("SELECT
SUM(duration_minutes + duration_seconds) as total
GROUP BY quantity,duration_minutes,
<?php echo ROUND($total); ?>
total is 1.688
I would like the result to be "2"
but rather it's giving me "17"
More help would be greatly appreciated.