adding up variables

[drollz]

Hello, again... Thank you to everyone who has helped me in the past.

My latest question deals with variables once again. I have a table with values stored for multiple rows. Example: points scored (value in column) for players (rows) in a table (list of players). If I display a specific (by team, by position, by hair color, etc.) list of players and their points scored, how can i find the sum of their points scored? This should be simple but it is killing me! Because when I extract "pts" (column) as $pts(variable), i cannot get the sum because each $pts overwrites the previous one.

Please keep in mind that i am a humble beginner, so be as specific as possible with your examples. Thanks in advance!

[planetsim]

Firstly what do mean by some of there scores?

Are you getting points from all feilds with that players id and wanting to count the scores..

and do you have code of what you have done so far.

[drollz]

Originally posted by planetsim
Firstly what do mean by some of there scores?

Are you getting points from all feilds with that players id and wanting to count the scores..

and do you have code of what you have done so far.

$getdata = "select * from 200001playerstats where playerid = $activeplayer";
$result = mysql_query($getdata);
while ( $row = mysql_fetch_array($result))
{
extract($row);

$fgpct = $fgm / $fga;
$f_fgpct = sprintf("%.3f", $fgpct);
echo "$year $fgm-$fga ($f_fgpct)<br>";
}

$getdata = "select from 200102playerstats where playerid = $activeplayer";
$result = mysql_query($getdata);
while ( $row = mysql_fetch_array($result))
{
extract($row);
$fgpct = $fgm / $fga;
$f_fgpct = sprintf("%.3f", $fgpct);
echo "$year $fgm-$fga ($f_fgpct)<br>";
}
$getdata = "select from 200203playerstats where playerid = $activeplayer";
$result = mysql_query($getdata);
while ( $row = mysql_fetch_array($result))
{
extract($row);
$fgpct = $fgm / $fga;
$f_fgpct = sprintf("%.3f", $fgpct);

echo "$year $fgm-$fga ($f_fgpct)<br>";
}

I want to get the sums of fgm and fga, for example

[timj]

How do you want to sum? Over the different tables? If any player is mentioned more than once (in multiple rows) of the same table, you should use a query like:
select playerid, sum(fgm), sum(fga) from 200001playerstats where playerid = $activeplayer group by playerid;
This should give you the sum of fgm and fga for 1 player in the table (eliminate "where playerid=...) to get the sums for all players).

To get the sums of fgm and fga for 1 player, just add up the values in your while-loop.
For instance:

 
$fgmtot=0;
$fgatot=0;
<your query code>
while($row=...)
{
extract($row); 
$fgmtot=$fgmtot+$fgm; /*add up to the total*/
/*same for fgatot*/
$fgpct = $fgm / $fga;
$f_fgpct = sprintf("%.3f", $fgpct);
echo "$year $fgm-$fga ($f_fgpct)<br>";
} 

If you want to have the sums for all players, you can modify like this:
-eliminate "where playerid=..." part from your queries
-use an array (assuming your playerids are numerical) of fgatot and fgmtot:
$fgmtot[$playerid]=$fgmtot[$playerid]+$fgm; or something like that.
After your queries, you can loop over the fgmtot and fgatot arrays (they now store the totals for each player, with playerid as index in the arrays).

I hope this helps.