Sort a 2d array by a column's values [duplicate]

Question

I have an array fetched from mysql database tables of type. I want to sort it in order of particular value.

$arr1 = array( array(12, 8, 5, 34), array(54, 87, 32, 10), array(23, 76, 98, 13), array(53, 16, 24, 19) );

How can I sort it by value? Like sorting by 2nd value should result to.

$arr1 = array( array(12, 8, 5, 34), array(53, 16, 24, 19), array(23, 76, 98, 13), array(54, 87, 32, 10) );

possible duplicate of How do I sort a multidimensional array in php, then again, if you fetch it from a database, the database probably can do it faster for you... — Wrikken
– Wrikken, Commented Oct 23, 2013 at 18:22
@Wrikken: array_multisort is one of those functions that I've never quite figured out how to use. — gen_Eric
– gen_Eric, Commented Oct 23, 2013 at 18:26

gen_Eric · Accepted Answer · 2013-10-23 18:24:02Z

I like to use usort to solve these problems.

$sortKey = 1; usort($arr1, function($a, $b) use($sortKey){ return $a[$sortKey] - $b[$sortKey]; });

gen_Eric · Accepted Answer · 2013-10-23 19:40:33Z

Got to agree with @RocketHazmat, array_multsort is a royal pain in the backside. usort is much easier to follow but I thought I'd have a go anyway:

$sortKey = 1; array_multisort(array_map(function($v) use($sortKey){ return $v[$sortKey]; }, $arr1), $arr1);

It only took 20 minutes... :(

Here's a demo: http://ideone.com/2rZYIz

Collectives™ on Stack Overflow

Sort a 2d array by a column's values [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related