Sort php array on one column and output to list

Question

I have created an array that is populated from a wordpress loop:-

<?php while ($recentPosts->have_posts()) : $recentPosts->the_post(); ?>
     
        $alisting []["questions"] = $questions; 
        $alisting []["id"] = $post->ID; 
        $alisting []["title"] = $post->post_title; 
      
<?php endwhile; ?>

This outputs

Array ( [0] => Array ( [questions] => 22 ) [1] => Array ( [id] => 1016 ) [2] => Array ( [title] => Cash Commons ) [3] => Array ( [questions] => 15 ) [4] => Array ( [id] => 811 ) [5] => Array ( [title] => The Poker Echo ) [6] => Array ( [questions] => 34 ) [7] => Array ( [id] => 437 ) [8] => Array ( [title] => VideoWTF.com ) [9] => Array ( [questions] => 34 ) [10] => Array ( [id] => 295 )

I need to sort this array by Questions in descending order and echo it out to a list so that I will have:-

ID       | Title           |  Question

1023       Cash Commons       43
987        Videowtf           34

etc

mauris · Accepted Answer · 2009-10-15 06:00:10Z

1

You will need to use the function uasort() - http://www.php.net/manual/en/function.uasort.php - and create a call back function to sort.

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

uasort($alisting,'sort_callback');

answered Oct 15, 2009 at 6:00

mauris

43.6k16 gold badges102 silver badges132 bronze badges

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

8 Comments

Jonathan Lyon Over a year ago

Thanks Mauris - doesn't seem to have worked. I wish it wasn't this hard. Here's the output using this:- $length = count($alisting); for ($i = 0; $i < $length; $i++) { echo $alisting[$i]['questions'].'<br>'; } 23 15 34 34 31 8

mauris Over a year ago

hi Jonathan, i noticed that your key is 'questions', not 'Question'. you might want to check that...

Jonathan Lyon Over a year ago

yep - I changed that function sort_callback($a, $b){ if ($a['questions'] == $b['questions']) { return 0; } return ($a['questions'] < $b['questions']) ? 1 : -1; }

mauris Over a year ago

Hi there i noticed it's because you are using $i for the index. the index are not changed, the order are. you might want to use var_dump to see it, or use a foreach.

Jonathan Lyon Over a year ago

This is driving me mad - why is it so hard - can someone please help with a code example that can work - I really need this

|

wnoveno · Accepted Answer · 2009-10-15 05:58:44Z

0

use array_multisort

answered Oct 15, 2009 at 5:58

wnoveno

5463 gold badges10 silver badges25 bronze badges

3 Comments

mauris Over a year ago

please elaborate answer and give examples.

mauris Over a year ago

@Mark i know. wnoveno should at least provide a better answer.

mickmackusa Jan 23 at 14:40

This hint should have been a comment instead of an answer.

Collectives™ on Stack Overflow

Sort php array on one column and output to list

2 Answers 2

8 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related