It gets a little more complicated than this. There are several teams (each
with 20 players) and then there is the team owner and then there is the
player position, etc. So to do this I would have to do some kind of a join
and so on - and to date haven't been able to figure this out with sums. I
would also have to do a second query (I am already doing one to get the
points for each player), so I might as well just use it and through the
results in an array and then total it from there - and thus my question of
how I total the array....
----- Original Message -----
From: "Marek Kilimajer" <[EMAIL PROTECTED]>
To: "Beauford.2002" <[EMAIL PROTECTED]>
Cc: "PHP General" <[EMAIL PROTECTED]>
Sent: Sunday, March 02, 2003 11:10 AM
Subject: Re: [PHP] Arrays and MySQL
> Cannot you just make MaSQL count it?
>
> $query = "select sum(goals), sum(assists), sum(points) from roster";
>
>
>
>
> Beauford.2002 wrote:
>
> >Hi,
> >
> >I have an array which I am trying to total but having some problems. Any
> >help is appreciated.
> >
> >Example: This is a hockey team and there are 20 players - I am selecting
> >the goals, assists, and points from each player and then want to have a
> >grand total of all goals, assists, and points.
> >
> >$query = "select goals, assists, points from roster";
> >
> >while ($line = mysql_fetch_row($result)) {
> >
> >$totals[] = $line;
> >
> >}
> >
> >I want to total $totals[0][4] through $totals[19][4], $totals[0][5]
through
> >$totals[19][5], etc. for each stat. I thought of putting them in a for
loop
> >and just adding them, but this seemed kind of messy and the long way
around
> >
> >Thanks
> >
> >
> >
> >
> >
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
