On 05/11/2010 02:17 PM, Paul Halliday wrote:
> On Tue, May 11, 2010 at 4:03 PM, Jim Lucas <[email protected]> wrote:
>> Paul Halliday wrote:
>>> On Tue, May 11, 2010 at 2:25 PM, Jim Lucas <[email protected]> wrote:
>>>> 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
>>>>
>>>
>>> I was actually hoping to have them arranged like:
>>>
>>> $col1[0] = INDIA
>>> $col2[0] = 112
>>> $col1[1] = CANADA
>>> $col2[1] = 272
>>> ...
>>>
>>> Thanks.
>>>
I would probably do this:
$col1 = $col2 = array();
while ($row = mysql_fetch_array($theData[0])) {
$country = lookup($row[1]);
if(($found = array_search($country, $col1)) !== false) {
$col2[$found] += $row[0];
} else {
$col1[] = $country;
$col2[] = $row[0];
}
}
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
