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

Reply via email to