Help me! Sum Question

[maya28]

I have a small stats table that I'd like to put on my page. I've entered all the data itself into mysql dbs. Each player has several lines of statistical data, so I created a php page that pulls all the data for the specific player. All I'd like to do now is get it so that the columns (all except lastname) sum in the last row...I've been through the forums but can't seem to find what I'm looking for. Can anyone help me? Here's the code I have:

<table width="100%" border="0" align="center" cellpadding="3" cellspacing="0" class="tdstyle">
 <tr>
 <td>lastname</td>
 <td>gp</td>
 <td>g</td>
 <td>a</td>
 <td>pts</td>
 <td>pim</td>
</tr>

<?php 
$sql = "SELECT * FROM " . $dbtable . " WHERE lastname ='xxx' ORDER BY year ASC;"; 
$result = mysql_query($sql, $dbh) or die( mysql_error() ); 

$colorc = 0; 
$colors = array('eaeaea', 'ffffff'); 

while($rows = mysql_fetch_array($result)) 
{ 
  $color = $colors[((int) $colorc++ & 1)]; 

  print "<tr style=\"background-color: $color\">";  

  print "<td nowrap>$rows[lastname]</td>"; 
  print "<td>$rows[rs_gp]</td>";  

  print "<td>$rows[rs_g]</td>";  

  print "<td>$rows[rs_a]</td>";  

  print "<td>$rows[rs_pts]</td>";  

  print "<td>$rows[rs_pim]</td>";  

  print "</tr>";
} 


?> 

</table>

[halojoy]

1. so what errors do you get when running this?

2. what is the diffenrence between
   a) your wanted output
   and
   b) the output you get
   ??

[maya28]

I don't get an error at all. It outputs the rows perfectly, exactly how I want it to, but without any kind of sum at the end.

So, for example, it outputs:
Player | GP | G | A | PTS | PIM
Jones | 62 | 1 | 8 | 9 | 48
Jones | 72 | 3 | 14 | 17 | 125

What I want is:
Player | GP | G | A | PTS | PIM
Jones | 62 | 1 | 8 | 9 | 48
Jones | 72 | 3 | 14 | 17 | 125
Total | 134 | 4 | 22 | 26 | 173

Does that make sense?

[halojoy]

<?php
/***
we can add 5 sum variables, that are 0 before while loop
***/

$gpsum=0; $gsum=0; $asum=0;$ptsum=0;$pimsum=0;
while($rows = mysql_fetch_array($result)) 
{ 
  $color = $colors[((int) $colorc++ & 1)]; 

  print "<tr style=\"background-color: $color\">";  

  print "<td nowrap>$rows[lastname]</td>"; 
  print "<td>$rows[rs_gp]</td>";  

  print "<td>$rows[rs_g]</td>";  

  print "<td>$rows[rs_a]</td>";  

  print "<td>$rows[rs_pts]</td>";  

  print "<td>$rows[rs_pim]</td>";  

  print "</tr>";

// add those point in each row to the sums
$gpsum += $rows[rs_gp]; 
$gsum += $rows[rs_g]; 
$asum += $rows[rs_a];
$ptsum += $rows[rs_pts];
$pimsum += $rows[rs_pim];
} 

// now after loop we add a final table row <tr> display
  print "<tr style=\"background-color: $color\">";  

  print "<td nowrap>Total:</td>"; 
  print "<td>$gpsum</td>";  

  print "<td>$gsum</td>";  

  print "<td>$asum</td>";  

  print "<td>$ptsum</td>";  

  print "<td>$pimsum</td>";  

  print "</tr>";
?> 

</table>

so only now to pray to the GOD of PHP he lets this work!

😉