'; $artist_name = mysql_result($result_artist,$select_artist-1,"name"); echo "
$artist_name
"; while($counter < $num_tags) { $artist_tag = mysql_result($result_tag,$counter,"artist"); $album_tag = mysql_result($result_tag,$counter,"album"); $song_title = mysql_result($result_tag,$counter,"title"); $artist_name = mysql_result($result_artist,$artist_tag-1,"name"); $album_name = mysql_result($result_album,$album_tag-1,"name"); if($album_name != $old_album){ // Echo Album Titles if ($artist_display != 0) // Stop ordered list echo "
"; if ($album_name == NULL) //Set Unknown to AlbumTitle $album_name = "Unknown"; echo '
'.$album_name.'
'; echo '
'; } echo '
'.$song_title.'
'; $old_album = $album_name; $artist_display++; $counter++; } echo "
"; echo '
phpMyamaroK
version 0.4-dev
'; ?>