Hi there - im having trouble doing a cumlative total. I want to add the total from each record to
the next record.
For Example
record / # of guests/ guest cum total
1 / 1 / 1
2 / 2 / 3
3 / 1 / 4
My code is listed below - i have a loop pulling all the data but dont know how incorporate the
cumlative on each line. I can sum all but not for each record
I highlight the code im having troubles with please help. I have searched high and low and cannot
figure out.
<table border="0" align="center" width="54%">
<!-- Table Header Row -->
<!-- Column 1 -->
<tr>
<!-- Column 1 -->
<td width="2%" bgcolor="#00FFFF"><p align="center"><small><font
face="Verdana">Number</font></small></td>
<!-- Column 2 -->
<td width="5%" bgcolor="#00FFFF"><p align="center"><small><font
face="Verdana">Year</font></small></td>
<!-- Column 3 -->
<td width="5%" bgcolor="#00FFFF"><small><font face="Verdana">Month</font></small></td>
<!-- Column 4 -->
<td width="6%" bgcolor="#00FFFF"><small><font face="Verdana">Day</font></small></td>
<!-- Column 5 -->
<td width="10%" bgcolor="#00FFFF"><p align="center"><small><font
face="Verdana">Type</font></small></td>
<!-- Column 6 -->
<td width="10%" bgcolor="#00FFFF"><p align="center"><small><font
face="Verdana">Center</font></small></td>
<!-- Column 7 -->
<td width="10%" bgcolor="#00FFFF"><p align="center"><small><font
face="Verdana">Guests</font></small></td>
<!-- Column 8 -->
<td width="10%" bgcolor="#00FFFF"><p align="center"><small><font
face="Verdana">Registered</font></small></td>
<!-- Column 9 -->
<td width="10%" bgcolor="#00FFFF"><p align="center"><small><font
face="Verdana">Effective</font></small></td>
<!-- Column 10 -->
<td width="10%" bgcolor="#00FFFF"><p align="center"><small><font
face="Verdana">Percentage</font></small></td>
<!-- Column 11 -->
<td width="10%" bgcolor="#00FFFF"><p align="center"><small><font face="Verdana">Cumulative
Total Guests (#)(calculation)</font></small></td>
<!-- Column 12 -->
<td width="10%" bgcolor="#00FFFF"><p align="center"><small><font face="Verdana">Cumulative
Total Registered (#)(calculation)</font></small></td>
</tr>
<?php
// connect to database
include ("db_connect.php");
$result = mysql_query("SELECT year, month, day, type, center, guests, registrations, effective,
percentage FROM stats WHERE il_id='$il_id' ORDER BY year ASC, month ASC, day ASC") or
die(mysql_error());
//$fields_num = mysql_num_fields($result);<br>
//$query = "SELECT * FROM avg_tally ORDER BY average DESC";
//$result = mysql_query($query, $mysql_link);
if(mysql_num_rows($result)) {
$rank = 1;
while($row = mysql_fetch_row($result))
{
print("</tr><tr>");
if($color == "#D8DBFE") {
$color = "#A6ACFD";
} else {
$color = "#D8DBFE";
}
?>
<!-- row 1 -->
<tr>
<!-- Column 1 rank -->
<td width="2%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$rank");?> </font></small></td>
<!-- Column 2 year -->
<td width="0%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$row[0]");?> </font></small></td>
<!-- Column 3 month -->
<td width="0%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$row[1]");?> </font></small></td>
<!-- Column 4 day -->
<td width="6%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$row[2]");?> </font></small></td>
<!-- Column 5 type -->
<td width="10%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$row[3]");?> </font></small></td>
<!-- Column 6 center -->
<td width="10%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$row[4]");?> </font></small></td>
<!-- Column 7 guests -->
<td width="10%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$row[5]");?> </font></small></td>
<!-- Column 8 regs-->
<td width="10%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$row[6]");?> </font></small></td>
<!-- Column 9 effective -->
<td width="10%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$row[7]");?> </font></small></td>
<!-- Column 10 percentage -->
<td width="10%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$row[8]");?> </font></small></td>
<!-- Column 11 Cum Guests -->
<?
// Cumm Guests and Cumm Regs Calculations
$g = ($row[5]); // guests
$r = ($row[6]); // registrations
$cumg = ($row[9]);
$cumr = ($row[10]);
$cg = $cumg + $g;
$cr = $cumr + $r;
?>
<td width="10%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$cg");?> </font></small></td>
<!-- Column 12 Cum Registrations -->
<td width="10%" bgcolor=<? print("$color");?>> <p align="center"><small><font
face="Verdana"><? print("$cr");?> [/U][/U]</font></small></td>
</tr>
<? $rank++;}} ?>
</table>
