How to order an array with db data

Question

I have an array that looks like this:

{ [0]=> array(4) { "20" ["date"]=> string(10) "2013-01-25" ["content"]=> string(3) "ref" }

and [1], [2]... looks the same.

I wonder how to order my array so [0] is the one the latest date. Changing to timestamp is not an opinion. Any ideas?

Dino Babu · Accepted Answer · 2013-02-28 03:56:41Z

1

use order by in your query.

ORDER BY date

answered Feb 28, 2013 at 3:56

Dino Babu

5,8093 gold badges26 silver badges33 bronze badges

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

1 Comment

William N Over a year ago

I was thinking if there's a way to do it with the array instead, there's multiple queries

Nir Alfasi · Accepted Answer · 2013-02-28 04:06:45Z

You can use usort() and write your own comparison function (a function that compares between "objects" - the inner arrays).

Since the dates are written in a way that enables simple string comparison you can do as follows:

<?php
function compare($arr1, $arr2) {
   $date1 = $arr1[0];
   $date2 = $arr2[0];
   if($date1 > $date2){
       $ans = 1;
   }
   else if($date2 > $date1){
       $ans = -1;
   }
   else{
       $ans = 0;
   }
   return $ans;
}

$arr = array(array("date"=>"2013-01-25", "content"=>"ref"), 
                array("date"=>"2013-02-25", "content"=>"ref2"), 
                array("date"=>"2013-03-25", "content"=>"ref3")
        );

usort($arr, "compare");
print_r($arr);

?>

OUTPUT:

Array
(
    [0] => Array
        (
            [date] => 2013-03-25
            [content] => ref3
        )

    [1] => Array
        (
            [date] => 2013-02-25
            [content] => ref2
        )

    [2] => Array
        (
            [date] => 2013-01-25
            [content] => ref
        )

)

Prasanth Bendra · Accepted Answer · 2013-02-28 04:30:30Z

0

Try this : This sorts multi dimensional array

$sort = array();
foreach($your_array as $k=>$v) {
    $sort['date'][$k] = $v['date'];
}

array_multisort($sort['date'], SORT_DESC, $your_array);


echo "<pre>";
print_r($your_array);

answered Feb 28, 2013 at 4:30

Prasanth Bendra

33.1k9 gold badges56 silver badges74 bronze badges

Collectives™ on Stack Overflow

How to order an array with db data

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related