Sort a 2d array by column of timestamp integers [duplicate]

Question

I have problem ordering an array in the way I want.

This is an example output of my array:

# 159 rows in total Array ( [0] => Array ( [0] => pastebin [1] => &nbsp; [2] => 1305025723 [3] => /fcTGqQGD ) [1] => Array ( [0] => pastebin [1] => &nbsp; [2] => 1305025723 [3] => /YQNk8yqa ) [2] => Array ( [0] => pastebin [1] => &nbsp; [2] => 1305025723 [3] => /u2BNPrad ) [3] => Array ( [0] => pastebin [1] => &nbsp; [2] => 1305025722 [3] => /d/blogdialain.com ) [4] => Array ( [0] => pastebin [1] => &nbsp; [2] => 1305025722 [3] => /d/shopcraze.com ) [5] => Array ( [0] => pastebin [1] => &nbsp; [2] => 1305025722 [3] => /domains_archive/175 ) [6] => Array ( [0] => pastebin [1] => &nbsp; [2] => 1305025722 [3] => /d/togou.com ) [7] => Array ( [0] => pastebin [1] => &nbsp; [2] => 1305025722 [3] => /W6NafmJa ) )

Complete array data here: http://pastebin.com/GJNBmqL7

Data comes from various database at once, so I'm limited in the way that I put the data into the array.

The [2] always contains a linux timestamp. Now I want the entire array to be ordered by that timestamp, with the lowest value first.

How can I get that done?

Community · Accepted Answer · 2023-11-17 19:32:19Z

12

here an array_multisort example:

foreach ($array as $key => $node) { $timestamps[$key] = $node[2]; } array_multisort($timestamps, SORT_ASC, $array);

edited Nov 17, 2023 at 19:32

CommunityBot

11 silver badge

answered May 10, 2011 at 11:33

mjspier

6,5565 gold badges35 silver badges47 bronze badges

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

Comments

Headshota · Accepted Answer · 2011-05-10 11:21:35Z

use usort that accepts custom function to sort arrays:

usort

your function may look something like:

function cmp($a, $b) { if ($a[2] == $b[2]) { return 0; } return ($a[2] < $b[2]) ? -1 : 1; }

Coin_op · Accepted Answer · 2011-05-10 11:23:58Z

You can do this simply by using a custom sort. So assuming your datestamp is always index 2:

function sortArray($a1, $a2){ if ($a1[2] == $a2[2]) return 0; return ($a1[2] > $a2[2]) ? -1 : 1; } usort($array, "sortArray");

Emil Vikström · Accepted Answer · 2011-05-10 11:24:18Z

5

usort is the easiest to work with, but you can also check out array_multisort.

answered May 10, 2011 at 11:24

Emil Vikström

92.3k17 gold badges144 silver badges178 bronze badges

Comments

Joshua - Pendo · Accepted Answer · 2011-05-10 11:22:00Z

0

Use usort and create your own function, http://php.net/manual/en/function.usort.php

answered May 10, 2011 at 11:22

Joshua - Pendo

4,4016 gold badges39 silver badges52 bronze badges

Comments

hsz · Accepted Answer · 2011-05-10 11:23:19Z

function cmp($a, $b) { if ($a[2] == $b[2]) { return 0; } return ($a[2] < $b[2]) ? -1 : 1; } $data = array( /* your data */ ); usort($data, "cmp");

Abel Mohler · Accepted Answer · 2011-05-10 11:23:34Z

It might be easier to insert the data into a single temporary table, then SELECT it, with ORDER BY timestamp

Blaztix · Accepted Answer · 2021-05-07 17:07:42Z

This can be achieved with following code:

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

This will result in sorted array of $variable, assuming time-stamp is at

$variable[0]['timestamp']; $variable[0]['timestamp'];

and so on.

Collectives™ on Stack Overflow

Sort a 2d array by column of timestamp integers [duplicate]

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related