[Resolved] trying to get a grand total

[dwilson]

Im trying to get a grand total here is the code I have used so far

$sql = "SELECT account_number,
account_name,
SUM(total)
FROM tbl1
GROUP BY(account_number)";
right know it work fines as far a giving a total for all transactions in every account, but what I would like now is to have a grand total at the end from all the account totals SUM(total). does anybody know how to do this

[stolzyboy]

well when you run through the results set you get something like

account 1 - 450
account2 - 456
etc...

so just add the total to itself when you hop through the results

[dwilson]

I dont mean to be a pest but I'm new to php as well as programming can you give me an example on how to add the total to itself please. Thanks for your help

[stolzyboy]

you have your query, then you have your result, do a while loop like this

while ($row = mysql_fetch_array($result1))
{
$total = $total + $row['total'];
}

then you can do

echo "Grand Total: " . $total;

[dwilson]

Thanks for your help thats exactly what I wanted

Thank you again

[stolzyboy]

no problem, if you feel this thread is indeed resolved, mark it resolved with the link below, if you can't get it to work, lemme know, i will mark it