include("/home2/thegaunt/www/common/bandheader.php");
include("/home2/thegaunt/www/common/connectdb.php");
$bid = $_GET['bid'];
$sid = $_GET['sid'];
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];
};
$sql1 = "SELECT * FROM bands WHERE bid='$bid'";
$result = mysql_query ($sql1, $link ) or die ('request "Could not execute SQL query" '.$sql1);
$row = mysql_fetch_object( $result );
$newname = preg_replace('/ /', '-', $row->band);
$sql = "UPDATE bands SET viewed=viewed+1 WHERE bid=$bid";
$result = mysql_query ($sql, $link ) or die ('request "Could not execute SQL query" '.$sql);
$sql = "SELECT * FROM showreview WHERE bid='$bid' AND sid='$sid' ";
$result = mysql_query ($sql, $link ) or die ('request "Could not execute SQL query" '.$sql);
$row = mysql_fetch_object( $result );
?>
echo band_name($row->bid); ?> Concert Review
echo nl2br("$row->review"); ?>
|
mysql_close($link);
?>