Sort the rows of a 2d array by a column value [duplicate]

Question

I have an array that loops through a set of a values, this is how it looks:

$arr[] = array(
    "name" => $name, 
    "add1" => $add1, 
    "add2" => $add2, 
    "add3" => $add3, 
    "postcode" => $pc, 
    "distance" => $distance
);

Simple and quick question (although I'm struggling with the answer), I was wondering how I can sort the array into distance ascending (which is a floating number) order?

Paul · Accepted Answer · 2013-07-05 14:01:28Z

3

You can use usort and compare the distance in your comparison function:

usort($arr, function($a, $b){
    return $a['distance'] - $b['distance'];
});

answered Jul 5, 2013 at 14:01

Paul

142k28 gold badges285 silver badges272 bronze badges

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

Comments

silkfire · Accepted Answer · 2013-07-05 14:04:36Z

2

Edit:

I think I understand what it is you want to achieve now. Try this:

function array_sort_by_column(&$array, $col, $direction = SORT_ASC) {
    $sort_col = array();

    foreach ($array as $key => $row) {
        $sort_col[$key] = $row[$col];
    }

    array_multisort($sort_col, $direction, $array);
}

array_sort_by_column($arr, 'distance');

edited Jul 5, 2013 at 14:04

answered Jul 5, 2013 at 13:58

silkfire

26.3k17 gold badges92 silver badges116 bronze badges

5 Comments

30secondstosam Over a year ago

Thanks for the answer - I have used the usual sort functions and they don't work.

silkfire Over a year ago

@30secondstosam Could you try my new solution?

30secondstosam Over a year ago

Worked a TREAT! great bit of code. I'll certainly re use that. thank you!! @silkfire

silkfire Over a year ago

@30secondstosam You're welcome. I use this custom function all the time.

30secondstosam Over a year ago

it's brilliant. Unfortunately StackOverflow has become a popularity contest, but this should be the answer that gets the votes.

ital0 · Accepted Answer · 2013-07-05 14:03:08Z

0

An alternative that I've found to organize my arrays is putting them as key, and then organizing with these keys.

Example (using your code):

$arr = array();    
$arr[$distance] = array("name" => $name, 
                   "add1" => $add1, 
                   "add2" => $add2, 
                   "add3" => $add3, 
                 "postcode" => $pc, 
           "distance" => $distance);

ksort($arr);

answered Jul 5, 2013 at 14:03

ital0

3442 silver badges8 bronze badges

Comments

Eineki · Accepted Answer · 2013-07-05 14:06:43Z

0

You can use the usort for sorting an array on personalized rules

<?php
    function sortOnDistance($a, $b) {
        if ($a['distance'] == $b['distance']) {
            return 0;
        }
        return ($a['distance'] < $b['distance']) ? -1 : 1;
    }

    usort($array, "sortOnDistance");
?>

answered Jul 5, 2013 at 14:06

Eineki

14.9k6 gold badges55 silver badges62 bronze badges

Collectives™ on Stack Overflow

Sort the rows of a 2d array by a column value [duplicate]

4 Answers 4

Comments

5 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

5 Comments

Comments

Comments

Linked

Related