----- 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);

?> 

Reply via email to