include("/home2/thegaunt/www/common/header-new.php"); include("/home2/thegaunt/www/common/connectdb.php"); import_request_variables("gP", ""); if(is_numeric($id)) { $sql = "UPDATE freshblood SET views=views+1 WHERE id=$id"; $result = mysql_query ($sql, $link ) or die ('request "Could not execute SQL query" '.$sql); function band_image($t_id) { global $link; $sql = "SELECT bandimage FROM photos WHERE pid = '$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 label($t_id) { global $link; $sql = "SELECT label FROM labels WHERE lid = '$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 label_url($t_id) { global $link; $sql = "SELECT l_url FROM labels WHERE lid = '$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_bio($t_id) { global $link; $sql = "SELECT bio FROM bandinfo 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_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 freshblood WHERE id='$id' " ); while ( $row = mysql_fetch_object( $result ) ) { $bandbio = band_bio($row->bid); $str=nl2br("$bandbio"); $bandname = band_name($row->bid); $bandname = preg_replace('/ /', '-', $bandname); ?>
The Gauntlet's Fresh Bloodecho band_name($row->bid); ?> |
|
Media Player This text will be replaced
echo "$row->songtitle"; ?> Bio echo substr($str, 0, 400); ?> bid"; ?>/ echo $bandname ?>.html">(read more) Links myspace"; ?>" target=_blank>MySpace echo label($row->lid); ?> |