|
|
Top CDs
$db = mysql_connect("localhost", "chartuser", "chrt11SDxx");
mysql_select_db("audibl2",$db);
$ofs=empty($_GET['ofs']) ? 0 : $_GET['ofs'];
if(empty($_GET['pub']) or $_GET['pub']=="all")
{
$getlist=mysql_query("select cdnum, value from afcdcharts order by value desc limit $ofs,100",$db);
}
elseif($_GET['pub']=='indie')
{
$getlist=mysql_query("select cdnum, value from afcdcharts where cdnum like 'cd0%' order by value desc limit $ofs,100",$db);
}
elseif($_GET['pub']=='integ')
{
$getlist=mysql_query("select cdnum, value from afcdcharts where cdnum like 'cd2%' order by value desc limit $ofs,100",$db);
}
elseif($_GET['pub']=='vine')
{
$getlist=mysql_query("select cdnum, value from afcdcharts where cdnum like 'cd80%' order by value desc limit $ofs,100",$db);
}
elseif($_GET['pub']=='imp')
{
$getlist=mysql_query("select cdnum, value from afcdcharts where cdnum like 'cd86%' order by value desc limit $ofs,100",$db);
}
elseif($_GET['pub']=='mar')
{
$getlist=mysql_query("select cdnum, value from afcdcharts where cdnum like 'cd82%' order by value desc limit $ofs,100",$db);
}
else
{
$getlist=mysql_query("select cdnum, value from afcdcharts order by value desc limit $ofs,100",$db);
}
$ofsb=$ofs+mysql_num_rows($getlist);
$ofn=mysql_num_rows($getlist);
$ofadd=$ofs+1;
if($get=mysql_fetch_row($getlist)) {
echo "Top CDs at AudibleFaith \n";
if (99 < $ofs) {
echo "Listing results $ofadd-$ofsb\n";
}
elseif ($ofn==100) {
echo "Listing results $ofadd-$ofsb\n";
}
else {
echo "\n";
}
echo "| Rank | Title | Artist | \n";
$i=$ofs+1;
do {
$gettitle=mysql_query("select title, artist from cds where cdnum='$get[0]'",$db);
if ($got=mysql_fetch_row($gettitle)) {
do {
echo "| $i | $got[0] | $got[1] | \n";
}
while($got=mysql_fetch_row($gettitle));
}
$i++;
}
while($get=mysql_fetch_row($getlist));
echo " \n";
echo "| \n";
if (99 < $ofs) {
$ofp=$ofs-100;
echo "Previous Page\n";}
else {
echo "\n";}
echo " | \n";
if ($ofn==100) {
echo " Next Page\n";}
else {
echo "\n";}
echo " | \n";
echo " | \n";
}
else {
echo "CD charts temporarily offline \n";
}
?>
|
|