How can I sort a multidimensional array using php?

Question

Hi I have to sort this array in desc. order on the basis of ratingVal using php. How can I do that.

Array
(
    [0] => Array
        (
            [rating_postid] => 26
            [raCnt] => 6
            [sRate] => 18
            [ratingVal] => 3
        )

    [1] => Array
        (
            [rating_postid] => 714
            [raCnt] => 3
            [sRate] => 14
            [ratingVal] => 4.6666666666667
        )

    [2] => Array
        (
            [rating_postid] => 14
            [raCnt] => 4
            [sRate] => 12
            [ratingVal] => 3
        )

    [3] => Array
        (
            [rating_postid] => 290
            [raCnt] => 2
            [sRate] => 10
            [ratingVal] => 5
        )

    [4] => Array
        (
            [rating_postid] => 194
            [raCnt] => 2
            [sRate] => 8
            [ratingVal] => 4
        )

    [5] => Array
        (
            [rating_postid] => 134
            [raCnt] => 2
            [sRate] => 6
            [ratingVal] => 3
        )

    [6] => Array
        (
            [rating_postid] => 707
            [raCnt] => 1
            [sRate] => 5
            [ratingVal] => 5
        )

)

I retagged your question to use more appropriate tags, e. g. dont use the PHP 5.3 tag if you actually do use 5.2.X. — BMBM
– BMBM, Commented Oct 27, 2010 at 10:56

outis · Accepted Answer · 2012-01-07 01:16:02Z

3

Use usort:

function sortIt( $a, $b ){
    return $b['ratingVal'] - $a['ratingVal'];
}

usort( $yourArray, "sortIt" );

For ascending order, swap the $a and $b in the subtraction.

The usort function allows you to create your own custom sort function

edited Jan 7, 2012 at 1:16

outis

77.7k23 gold badges155 silver badges228 bronze badges

answered Oct 27, 2010 at 10:35

Harmen

22.5k4 gold badges57 silver badges77 bronze badges

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

2 Comments

lonesomeday Over a year ago

+1 (a) because your code is the way to do this and (b) because I stole it for my answer!

outis Over a year ago

Any reason you didn't use function sortIt($a, $b) {return $b['ratingVal']-$a['ratingVal'];} ?

Kel · Accepted Answer · 2010-10-27 10:37:16Z

1

If you retrieve this data from mysql database (as I see, mysql tag is specified), you may use ORDER BY statement in your query.

If this is not suitable, you'll have to implement comparison function and use usort() function.

answered Oct 27, 2010 at 10:37

Kel

7,8103 gold badges32 silver badges39 bronze badges

Comments

lonesomeday · Accepted Answer · 2010-10-27 10:43:51Z

1

You've tagged your code "php5.3", so I'm going to give a 5.3-specific answer.

Adapting Harmen's code:

usort( $yourArray, function($a, $b) {
    if( $a['ratingVal'] == $b['ratingVal'] )
        return 0;
    return ( $a['ratingVal'] < $b['ratingVal'] ) ? 1 : -1;
} );

This uses usort and anonymous functions, a new addition in PHP 5.3.

answered Oct 27, 2010 at 10:43

lonesomeday

239k54 gold badges330 silver badges329 bronze badges

1 Comment

learner Over a year ago

sorry sir I am using php 5.2.6

Collectives™ on Stack Overflow

How can I sort a multidimensional array using php?

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related