Id(), "SUM(play_time)" ); $years = mysql_select_assoc( "tbl_Song", "genre=" . $genre->Id(), "MIN(release_year) AS syear,MAX(release_year) AS eyear" ); if( $years['syear'] == $years['eyear'] ) { $release_years = $years['syear']; } else { $release_years = $years['syear'] . " - " . $years['eyear']; } ?>

%s", htmlencode( $genre->Name() ) ); ?>

Genre: Name() ); ?> Years: Play Time: Description: Description() ); ?> GenreIds( $genre->Id() ); $search->SetSearchType( "album" ); $search->SortBy("tbl_Album.album"); $all_complete = 1; $num_complete = 0; while( $album = $search->Next() ) { if( !$album->Complete() ) { $all_complete = 0; continue; } $num_complete++; printf( "\n", AlternateColor(), $album->Id(), $album->Name() ); printf( "\n", $album->Artist(), $album->Artist() ); printf( "\n", $album->Playtime() / 60, $album->Playtime() % 60 ); printf( "\n", $album->ReleaseYear() ); } if( $num_complete == 0 ) { print "\n"; } if( !$all_complete ) { print "\n"; $search->Rewind(); while( $album = $search->Next() ) { if( $album->Complete() || $album->Id() == 0 ) continue; printf( "\n", AlternateColor(), $album->Id(), $album->Name() ); printf( "\n", $album->Artist(), $album->Artist() ); printf( "\n", $album->Playtime() / 60, $album->Playtime() % 60 ); printf( "\n", $album->ReleaseYear() ); } } ?> Album Artist Time Release Year %s %s %d:%02d %s There are no complete albums. -- Incomplete Albums -- %s %s %d:%02d %s GenreIds( $genre->Id() ); $search->SetSearchType( "artist" ); $search->SortBy("tbl_Artist.artist"); while( $artist = $search->Next() ) { printf( "\n", AlternateColor(), $artist->Id(), $artist->Name() ); printf( "\n", $artist->Playtime() / 60, $artist->Playtime() % 60 ); printf( "\n", $artist->ReleaseYears() ); } ?> Artist Time Release Years %s %d:%02d %s