include("/home2/thegaunt/www/common/header.php");
include("/home2/thegaunt/www/adm/connectdb.php");
?>
Top Bands
import_request_variables("gP", "");
$QUERY_STRING = $genre;
$result = mysql_query( "SELECT * FROM bands WHERE genre = '$genre' ORDER BY 'viewed' DESC LIMIT 0,10" );
while ( $row = mysql_fetch_object( $result ) )
{
$newname = preg_replace('/ /', '-', $row->band);
echo "- bid/$newname.html\">$row->band
\n";
}
?>
include("/home2/thegaunt/www/common/bandfooter.php");
?>