HELP - Getting TOTAL from total in Rows

[camarosource]

I am fairly new to PHP and am having a bit of troubles. Sample Code would be very much appreciated.

I have a PHP script http://camarosource.ca/2006_calendars/list.php loads http://camarosource.ca/2006_calendars/list.htm
This displays new cell rows via PHP's "ROW" command. It displays the results from a database. In the script it then displays the total of each row on the screen and into a variable ($CALENDAR_TOTAL).

At the end of the list it creates, I have a final row where I would like various totals to display. In this case, I am TRYING to figure out how to get the FINAL total of all the subtotals that display on the screen but am having GREAT difficulties. Basically by looking at the totals you would see I am wanting to add 6 + 4 + 5 + 2 + 5 + 1 + 5 ........ and so forth.. you'll understand when you see the script http://camarosource.ca/2006_calendars/list.php

I want to display the COMPLETE total in the (FULL TOTAL) cell.

HELP.

Here is the code http://camarosource.ca/2006_calendars/list.phps

[tunage]

Just create a variable before the while loop, then add the subtotals to that every time you go through the loop...

$total = 0;

// Format list by row 
while ($row = mysql_fetch_array($sql_result)) { 

.....

$CALENDAR_QUANTITY = $FIRST_GEN_QTY + $SECOND_GEN_QTY + $THIRD_GEN_QTY_VER_ONE + 

$total += $CALENDAR_QUANTITY;

.....
}