> You can use array_sum().
I have used that in the past, but only on single arrays, I can't figure out
how to do on multi-level arrays, and since I need to have different totals
from different levels of the array, I don't think this will work. If you can
shed some light on this it would be appreciated.
>From below - $totals[0][4] through $totals[19][4] , $totals[0][5] through
$totals[19][5], etc.
----- Original Message -----
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 02, 2003 4:53 PM
Subject: Re: [PHP] Arrays and MySQL
> On Sunday 02 March 2003 23:34, 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
>
> You can use array_sum().
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
> ------------------------------------------
> Search the list archives before you post
> http://marc.theaimsgroup.com/?l=php-general
> ------------------------------------------
> /*
> Man's unique agony as a species consists in his perpetual conflict between
> the desire to stand out and the need to blend in.
> -- Sydney J. Harris
> */
>
>
> --
> 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
