|
//call the correct script to display reviews based on genre
//first we figure out what genre, then run the correct script
/* "$QUERY_STRING" is the genre after the question
mark in the genre given above */
import_request_variables("gP", "");
//$QUERY_STRING = $id;
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];
};
function band_image($t_id) {
global $link;
$sql = "SELECT bandimage 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 thegauntlet WHERE bid = $bid" );
while ( $row = mysql_fetch_object( $result ) )
{
$stream_path = "http://www.thegauntlet.com/audiostream.php?id=$row->id";
// Printing results in HTML
echo "";
echo "";
echo band_name($row->bid);
echo "";
echo " ";
include("/var/www/html/bands/$row->bandfile.html");
echo " | \n";
echo "\n\n";
?>
echo "Bio\n";
echo "bid);
echo "\" alt=\"band photo\" height=130 border=0 align=\"left\">\n";
echo "\n";
echo "$row->bio_short\n\n \n";
echo "bid\">";
echo band_name($row->bid);
echo " bio\n";
echo " \n";
echo "Links\n\n";
echo "\n";
echo " | ";
?>
}
$result = mysql_query( "SELECT datum FROM thegauntlet WHERE bid = $bid" );
while ( $row = mysql_fetch_object( $result ) )
{
echo "\nPage Updated: $row->datum";
}
echo "\n | ";
// Closing connection
mysql_close($link);
?>
|