Re: Array group and sum values.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Paul Halliday wrote:
> I have this:
> 
> while ($row = mysql_fetch_array($theData[0])) {
> 
>     $col1[] = $row[0];
>     $col2[] = lookup($row[1]); // this goes off and gets the country name.
> 
> I then loop through col1 and col2 to produce something like this:
> 
> 52  	ARMENIA
> 215 	CANADA
> 57 	CANADA
> 261 	COLOMBIA
> 53 	EGYPT
> 62 	INDIA
> 50 	INDIA
> 
> Is there a way I can group these?
> 
> Thanks!
> 

Group them??

How about this

while ($row = mysql_fetch_array($theData[0])) {

    $col1[lookup($row[1])][] = $row[0];

which, using the data you showed, will give you this


Array
(
    [ARMENIA] => Array
        (
            [0] => 52
        )

    [CANADA] => Array
        (
            [0] => 215
            [1] => 57
        )

    [COLOMBIA] => Array
        (
            [0] => 261
        )

    [EGYPT] => Array
        (
            [0] => 53
        )

    [INDIA] => Array
        (
            [0] => 62
            [1] => 50
        )

)

-- 
Jim Lucas

   "Some men are born to greatness, some achieve greatness,
       and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V
    by William Shakespeare

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux