Question

0

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

Can someone please help with very clear instructions please.

Thanks in advance of your help.

Cheers

Jonathan

flag	asked Oct 15 at 5:56 Jonathan Lyon 129●8 33% accept rate

Mauris · Answer 1 · 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 at 6:00

Mauris
1,601●11

	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 – Jonathan Lyon Oct 15 at 6:16
	hi Jonathan, i noticed that your key is 'questions', not 'Question'. you might want to check that... – Mauris Oct 15 at 6:23
	yep - I changed that function sort_callback($a, $b){ if ($a['questions'] == $b['questions']) { return 0; } return ($a['questions'] < $b['questions']) ? 1 : -1; } – Jonathan Lyon Oct 15 at 6:26
	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. – Mauris Oct 15 at 6:32
	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 – Jonathan Lyon Oct 15 at 6:41

show 3 more comments

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

0

use array_multisort

answered Oct 15 at 5:58

wnoveno
9●1

	please elaborate answer and give examples. – Mauris Oct 15 at 6:01
	us2.php.net/manual/en/… – Mark Oct 15 at 6:16
	@Mark i know. wnoveno should at least provide a better answer. – Mauris Oct 15 at 6:22

Sort php array on one column and output to list

2 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged array sort sorting php or ask your own question.

Hello World!

Related