----- Original Message -----
From: "bryan_is_south"
Hello,
I have a multidimensional array, and would like to sort it by the
value of the last array.
Here's the idea of what I've got:
$Scores[$artist][$album]=$avg;
So the $Scores array contains an array for each artist, and each
$artist array contains an array for each album by them. The value for
the $album array is the average score for the album.
I want to sort this multidimensional array by the $avg, but I can't
figure it out.
Suggestions are much appreciated.
Thank you in advance
-bryan
------------------------------------
<?php
function init_scores()
{
$artist_count = rand(3,5);
for($artist_number = 1; $artist_number <= $artist_count; $artist_number++)
{
$artist_name = 'Artist number ' . $artist_number;
$album_count = rand(5,7);
for($album_number = 1; $album_number <= $album_count; $album_number++)
{
$album_name = 'Album number ' . $album_number;
$array[$artist_name][$album_name]= rand(1,10);
}
}
return $array;
}
function show_array($array)
{
echo('<table border="1">'. "\n");
echo("<tr><th>Artist</th><th>Album</th><th>Rating</th></tr>\n");
foreach($array as $artist_name => $albums)
{
foreach($albums as $album_name => $rating)
{
echo("<tr>");
echo("<td>" . $artist_name . "</td>");
echo("<td>" . $album_name . "</td>");
echo("<td>" . $rating . "</td>");
echo("</tr>\n");
}
}
echo("</table>\n\n");
}
function sort_order($array)
{
foreach($array as $artist_name => $albums)
{
foreach($albums as $album_name => $rating)
{
$order[] = array('artist_name' => $artist_name, 'album_name' =>
$album_name);
$ratings[] = $rating;
}
}
// Bubble sort
for($compare_end_index = count($ratings) - 2; $compare_end_index >= 0;
$compare_end_index--)
{
for($compare_index = 0; $compare_index <= $compare_end_index;
$compare_index++)
{
if($ratings[$compare_index] > $ratings[$compare_index + 1])
// change the '>' above to '<' to reverse the sort order
{
$temp = $ratings[$compare_index];
$ratings[$compare_index] = $ratings[$compare_index + 1];
$ratings[$compare_index + 1] = $temp;
$temp = $order[$compare_index];
$order[$compare_index] = $order[$compare_index + 1];
$order[$compare_index + 1] = $temp;
}
}
}
return $order;
}
function show_ordered_array($array, $order)
{
echo('<table border="1">'. "\n");
echo("<tr><th>Artist</th><th>Album</th><th>Rating</th></tr>\n");
foreach($order as $keys)
{
$artist_name = $keys['artist_name'];
$album_name = $keys['album_name'];
$rating = $array[$artist_name][$album_name];
echo("<tr>");
echo("<td>" . $artist_name . "</td>");
echo("<td>" . $album_name . "</td>");
echo("<td>" . $rating . "</td>");
echo("</tr>\n");
}
echo("</table>\n\n");
}
$Scores = init_scores();
show_array($Scores);
$order = sort_order($Scores);
show_ordered_array($Scores, $order);
?>