How to sort a multi-dimensional array by a 4th level value in PHP

Question

I have an array which is converted from an XML response. What I need to do is sort the array ascending alphabetically using the 'COMPANY' value.

I have attempted to use array_multisort, but I'm having no luck at all. Any help would be greatly appreciated.

Here is the array:

array(1) {
  ["DATASOURCE"]=>
  array(1) {
    ["MEMBER"]=>
    array(4) {
      [0]=>
      array(4) {
        ["REFNO"]=>
        string(6) "000762"
        ["STATUS"]=>
        string(5) "CURRE"
        ["DATE"]=>
        string(8) "20100731"
        ["COMPANY"]=>
        string(80) "Tresham Institute Business Solutions                                            "
      }
      [1]=>
      array(4) {
        ["REFNO"]=>
        string(6) "003721"
        ["STATUS"]=>
        string(5) "CURRE"
        ["DATE"]=>
        string(8) "20100930"
        ["COMPANY"]=>
        string(80) "Triad esign                                                                    "
      }
      [2]=>
      array(4) {
        ["REFNO"]=>
        string(6) "011412"
        ["STATUS"]=>
        string(5) "CURRE"
        ["DATE"]=>
        string(8) "20100630"
        ["COMPANY"]=>
        string(80) "Transpower Drives Ltd                                                           "
      }
      [3]=>
      array(4) {
        ["REFNO"]=>
        string(6) "059647"
        ["STATUS"]=>
        string(5) "CURRE"
        ["DATE"]=>
        string(8) "20100630"
        ["COMPANY"]=>
        string(80) "Trek-Kits Ltd                                                                   "
      }
    }
  }
}

cHao · Accepted Answer · 2010-04-20 09:14:00Z

6

You'll need a function that takes the two items to be sorted, and compares them.

function sort_by_company($a, $b)
{
    return strcmp($a['COMPANY'], $b['COMPANY']);
}

Then, use the usort function.

usort($arr['DATASOURCE']['MEMBER'], 'sort_by_company');

answered Apr 20, 2010 at 9:14

cHao

87k21 gold badges147 silver badges178 bronze badges

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

Comments

Florent · Accepted Answer · 2012-08-24 15:41:51Z

0

You can use usort() PHP function.

edited Aug 24, 2012 at 15:41

Florent

12.4k10 gold badges51 silver badges58 bronze badges

answered Apr 20, 2010 at 9:12

Karthik

3,3415 gold badges31 silver badges38 bronze badges

1 Comment

Karthik Over a year ago

Please refer this post stackoverflow.com/questions/2672900/…

Collectives™ on Stack Overflow

How to sort a multi-dimensional array by a 4th level value in PHP

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related