[PHP] Arrays and MySQL
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
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
Re: [PHP] Arrays and MySQL
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
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
Re: [PHP] Arrays and MySQL
On March 2, 2003 01:53 pm, Jason Wong wrote:
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().
What about SELECT SUM(Goals), SUM(assists)?
Leo
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Arrays and MySQL
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
