Sum of Table Row`s

Hi,
(my writen english in not the best so .... )

i want to correcty insert the syntax from my code in "Where SQL"
now i put the code into "footer" but this way i think is not correct

i want to summate columns like this (i post the completly code)
noting in "where sql"

header

statistik von spieler hans
{pagination}
<table border="0" width="300" cellspacing="0" cellpadding="0" id="table1">
  <tr>
                <td>Tag</td>
    <td>Trainingszeiten</td>
    <td>Spielzeiten</td>
  </tr>

body

        <tr>
                <td>{cf_id}</td>
    <td>{text_0}</td>
    <td>{text_1}</td>
  </tr>

footer

<?php
$DBhost = "localhost";
$DBuser = "myusername";
$DBpass = "mypasswort";
$DBName = "mydbname";
$table = "jos_chronoforms_Spielerstatistik";
$sum1 = 0;
$sum2 = 0;
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
mysql_select_db("$DBName") or die("Unable to select database $DBName");
$result = mysql_query("SELECT * FROM $table");
while ($row = mysql_fetch_row($result)) {
   $sum1 += $row[5];
   $sum2 += $row[6];
   }
?>        
<tr>
    <td>Gesamt</td>
    <td><?php print "$sum1"; ?></td>
    <td><?php print "$sum2"; ?></td>
</tr></table>

it works so far but i think the way is not correct and i want do the statement in "where sql" section

please help me
thank a lot

Andy

Hi Andy,

try to write

<?php echo count($rows); ?>

any where in the header, body or footer and see if this works ?

Max

first thanks a lot
but i think i ask false
i dont want count the rows and also not the calculation in footer

result exaple

No    Training   Game
1       10        10
2       30        60
___________________________
result  40        70

the code in footer works but i think its there false and it will be better in "where sql" without the doubled sql login

sorry form my bad english :?

Hi qwarx,

maybe try this in the header :

<?php $totalresult = 0; ?>

in body :

<?php
$totalresult = $totalresult + $row->game;

?>

in footer:

<?php

echo $totalresult ;
?>

Max