|
|
Top Songs and CDs
Check out the top songs and CDs at AFSanctum.com. These living breathing charts reflect what the visitors of AFSanctum.com are checking out and purchasing. Check out the overall charts as shown on this page, or browse the charts by publisher.
\n";
do {
$gettitle=mysql_query("select title, artist from cds where cdnum='$get[0]'",$db);
if ($got=mysql_fetch_row($gettitle)) {
echo "\n";
do {
$covernum=substr($get[0], 2, 6);
if ($got[1]) {
echo "![](\"http://www.audiblefaith.com/music/albums/covers/mc$covernum.gif\") | $got[0] - $got[1] | \n";
}
else {
echo " | $got[0] | \n";
}
}
while($got=mysql_fetch_row($gettitle));
echo " \n";
}
}
while($get=mysql_fetch_row($getlist));
echo "
List More CDs
\n";
}
else {
echo "CD charts temporarily offline
\n";
}
echo " | \n";
$getlist=mysql_query("select songnum, value from sasgcharts order by value desc limit 0,20",$db);
if($get=mysql_fetch_row($getlist)) {
echo "Top 20 Songs at AFSanctum
\n";
do {
$gettitle=mysql_query("select title, author from songs where songnum='$get[0]'",$db);
if ($got=mysql_fetch_row($gettitle)) {
do {
if($got[1]) {
echo "$got[0] by $got[1]
\n";
}
else {
echo "$got[0]
\n";
}
}
while($got=mysql_fetch_row($gettitle));
}
}
while($get=mysql_fetch_row($getlist));
echo "
List More Songs
\n";
}
else {
echo "Song charts temporarily offline.
\n";
}
?>
|
|
