<?
# charts.php
#
# Shows most popular songs
#
$phpgw_info["flags"] = array ("currentapp" => "tunez",
							 "enable_nextmatchs_class" => True);
							 
include ("../header.inc.php"); #PHP Groupware header

if (!$aantal) { $aantal=10; }

include ("tunez.inc.php");

$title = "Top $aantal";
include ("header.inc.php");

echo "<a href=\"$PHP_SELF?aantal=10\">Top 10</a> | ";
echo "<a href=\"$PHP_SELF?aantal=40\">Top 40</a> | ";
echo "<a href=\"$PHP_SELF?aantal=100\">Top 100</a> | ";
echo "<a href=\"$PHP_SELF?aantal=1000\">Top 1000</a>";
echo "<BR><BR>\n";


$kweerie = "SELECT * FROM songs WHERE timesPlayed > 0 ORDER BY timesPlayed DESC, artist, songtitle LIMIT $aantal";

echo "<b>Out of the " . nrOfSongs() . " songs in the database, these are your $aantal favorite</b><BR><BR>\n";

listSongs($kweerie, "ja", "ja");

include ("footer.inc.php");


?>