include("/home2/thegaunt/www/common/header-new.php"); include("/home2/thegaunt/www/adm/connectdb.php"); ?>
Top User Rated Albums |
Bottom User Rated Albums |
|
function band_name($t_id) {
global $link;
$sql = "SELECT band FROM bands WHERE bid = '$t_id'" ;
$sql_result = mysql_query ($sql, $link ) or die ('request "Could not execute SQL query"');
$row = mysql_fetch_row( $sql_result );
return $row[0];
};
$result = mysql_query( "SELECT * FROM albums ORDER BY userrate DESC LIMIT 0,20" );
while ( $row = mysql_fetch_object( $result ) )
{
$band_name = band_name($row->bid);
$newname = preg_replace('/ /', '-', $band_name);?>
bid/$row->aid/$newname.html"; ?>">cover"; ?>" alt=" echo band_name($row->bid); ?>" width=100 height=100> echo band_name($row->bid); ?> - echo "$row->title"; ?> } ?> |
$result = mysql_query( "SELECT * FROM albums ORDER BY userrate ASC LIMIT 0,20" );
while ( $row = mysql_fetch_object( $result ) )
{
$band_name = band_name($row->bid);
$newname = preg_replace('/ /', '-', $band_name);?>
bid/$row->aid/$newname.html"; ?>">cover"; ?>" alt=" echo band_name($row->bid); ?>" width=100 height=100> echo band_name($row->bid); ?> - echo "$row->title"; ?> } ?> |