Sorting php array of arrays by 3 fields

Question

So I need to implement sorting show on this website:

http://news.bbc.co.uk/sport2/hi/olympics/medals_table/default.stm

And part of my array looks like this:

[1] => Array
    (
        [country_id] => 3
        [country_name] => Russia
        [gold] => 23
        [silver] => 21
        [bronze] => 28
        [total] => 72
    )

[2] => Array
    (
        [country_id] => 189
        [country_name] => USA
        [gold] => 36
        [silver] => 38
        [bronze] => 36
        [total] => 10
    )

[3] => Array
    (
        [country_id] => 230
        [country_name] => Germany
        [gold] => 16
        [silver] => 10
        [bronze] => 15
        [total] => 41
    )

[4] => Array
    (
        [country_id] => 231
        [country_name] => China
        [gold] => 51
        [silver] => 21
        [bronze] => 28
        [total] => 100
    )

So I need to sort array by gold,silver,bronze and then country_name.

Does anyone have some idea for this ?

What are your sorting parameters? It looks like individual weights have been given to each metal type, like a point system. Then you sort based on total points. — Sam Heuck
– Sam Heuck, Commented Mar 19, 2012 at 18:37
this is for olimpic games please see the link in question body. — Splendid
– Splendid, Commented Mar 19, 2012 at 18:38

Toto · Accepted Answer · 2012-03-19 19:32:47Z

1

use uasort function :

$arr = array(
  Array(
    'country_id' => 3,
    'country_name' => 'Russia',
    'gold' => 23,
    'silver' => 21,
    'bronze' => 28,
    'total' => 72,
  ),
  Array(
    'country_id' => 189,
    'country_name' => 'USA',
    'gold' => 36,
    'silver' => 38,
    'bronze' => 36,
    'total' => 10,
  ),
  Array(
    'country_id' => 230,
    'country_name' => 'Germany',
    'gold' => 16,
    'silver' => 10,
    'bronze' => 15,
    'total' => 41,
  ),
  Array(
    'country_id' => 231,
    'country_name' => 'China',
    'gold' => 51,
    'silver' => 21,
    'bronze' => 28,
    'total' => 100,
  )
);

function mySort($a,$b) {
    if ($b['gold'] == $a['gold']) {
        if ($b['silver'] == $a['silver']) {
            if ($b['bronze'] == $a['bronze']) {
                return strcmp($b['country_name'], $a['country_name']);
            } else {
                return $b['bronze'] - $a['bronze'];
            }
        } else {
            return $b['silver'] - $a['silver'];
        }
    } else {
        return $b['gold'] - $a['gold'];
    }
}

uasort($arr, 'mySort');
print_r($arr);

output:

Array
(
[1] => Array
    (
        [country_id] => 189
        [country_name] => USA
        [gold] => 36
        [silver] => 38
        [bronze] => 36
        [total] => 10
    )

[0] => Array
    (
        [country_id] => 3
        [country_name] => Russia
        [gold] => 23
        [silver] => 21
        [bronze] => 28
        [total] => 72
    )

[3] => Array
    (
        [country_id] => 231
        [country_name] => China
        [gold] => 51
        [silver] => 21
        [bronze] => 28
        [total] => 100
    )

[2] => Array
    (
        [country_id] => 230
        [country_name] => Germany
        [gold] => 16
        [silver] => 10
        [bronze] => 15
        [total] => 41
    )

)

edited Mar 19, 2012 at 19:32

answered Mar 19, 2012 at 18:43

Toto

91.7k63 gold badges97 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Splendid Over a year ago

I will analyze this - thanks but your output is not ok :) Since chine has most gold medals China should be on first place - news.bbc.co.uk/sport2/hi/olympics/medals_table/default.stm

Toto Over a year ago

@Splendid: yes, corrected. I first sort ascending, then invert all $a and $b except one :(

Stefan Marinov · Accepted Answer · 2012-03-19 18:33:35Z

0

I know of two options:

usort() to sort the array by values using a user-defined comparison function;
ksort() to sort the array by key.

Hope this answer is helpful enough.

answered Mar 19, 2012 at 18:33

Stefan Marinov

5814 silver badges14 bronze badges

Comments

safarov · Accepted Answer · 2012-03-19 18:48:44Z

0

Probably there is shorter way u can find. But this may also help

function my_sort($a, $b) {
    if($a['gold'] > $b['gold']) {
        return -1;
    }
    elseif ($a['gold'] == $b['gold']) {
        if($a['silver'] > $b['silver']) {
            return -1;
        }
        elseif ($a['silver'] == $b['silver']) {
          if ($a['bronze'] > $b['bronze']) {
              return -1;
            }
            elseif ($a['bronze'] == $b['bronze']) {
            return strcmp($b['country_name'], $a['country_name']);
           }
          return 1;
        }
      return 1;
    }
    return 1;
}

usort($arr, 'my_sort');

print_r($arr);

edited Mar 19, 2012 at 18:48

answered Mar 19, 2012 at 18:43

safarov

7,7942 gold badges38 silver badges52 bronze badges

Collectives™ on Stack Overflow

Sorting php array of arrays by 3 fields

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related