Solved

# sorting a mutli-dimensional array in PHP

Posted on 2011-02-16
216 Views
Hi there,

Well, the saga which is my first web application continues.  I recently had some help with an algorithm which calculates wins using a monthly tennis house-league matrix of scores and it works great.  But, with my limited exposure to web programming I've again reached a bit of a snag.

I have a 'Top Guns' sidebar.  I would like it to display the top 3 players in every house.  The information includes Name, Total Points, and now, Wins.  Here's what I'm looking to do...I would like the players to be sorted by Wins, and then by Total Points.  For example, if two players have 2 wins each..the one with the most points total points would appear ahead of the other guy.  Here's how my multi-dimensional array looks :

``````Array
(
[0] => Array
(
[name] => Player 1
[wins] => 3
[score] => 24
)

[1] => Array
(
[name] => Player 2
[wins] => 0
[score] => 13
)

[2] => Array
(
[name] => Player 3
[wins] => 1
[score] => 12
)

[3] => Array
(
[name] => Player 4
[wins] => 2
[score] => 18
)

)
``````

I have the code to populate the array all set, I just need to be able to sort it according to my specifications.  Any help would be greatly appreciated!
0
Question by:duder78
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 15

Accepted Solution

ncoo earned 500 total points
ID: 34910045
Just pass your array in to: usort(\$array, "winScore");

Details: http://uk3.php.net/usort

See code below.
``````<?php

\$array = array(0 => array
(
'name' => 'Player 1',
'wins' => '3',
'score' => '24'
),

1 => array
(
'name' => 'Player 2',
'wins' => '0',
'score' => '13'
),

2 => array
(
'name' => 'Player 3',
'wins' => '1',
'score' => '12'
),

3 => array
(
'name' => 'Player 4',
'wins' => '2',
'score' => '18'
)

);

function winScore(\$a, \$b)
{
if (\$a['wins'] == \$b['wins']) {
if (\$a['score'] == \$b['score']) {

return 0;
}
return (\$a['score'] < \$b['score']) ? 1 : -1;
}
return (\$a['wins'] < \$b['wins']) ? 1 : -1;
}

usort(\$array, "winScore");

echo '<pre>';
print_r(\$array);
``````
0

Author Closing Comment

ID: 34910178
Works like a champ, thanks alot!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

MySQL-Design Help 12 66
How to open a new browser tab after executing php script 20 47
Form not executing correctly 1 26
integrated two Separate file . 3 29
Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and tâ€¦
This article discusses how to implement server side field validation and display customized error messages to the client.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creatâ€¦
###### Suggested Courses
Course of the Month7 days, 2 hours left to enroll