Please try again later.

Click here to return or go back to the homepage."; include("footer.php"); } else { $pagetitle = "Label: $name1"; $titleImage = "homepage_title.gif"; $meta_keywords = "$name1 record label"; $meta_description = "$name1: $desc1 - Record Label"; $titleText = $name1; include("header.php"); if (isset($fremail)) { $temp = mysql_query("SELECT * FROM labels WHERE id=$id"); $artistname = mysql_result($temp, 0, name); $fremail = strtolower($fremail); $fremail = formatField($fremail); if(strlen($fremail) < 1) $error1 = "ERROR: You must enter an email address."; elseif(!isValidEmail($fremail)) $error1 = "ERROR: This is not a valid email address."; else { $notallowed = array("[", "]", "{", "}", ",", "*", "&", "^", "%", "/", "|", ";", ":", "?", "'", "(", ")"); $artistnamelink = str_replace($notallowed,"",$artistname); $artistnamelink = str_replace(" ","-",$artistnamelink); $artistnamelink = strtolower($artistnamelink); $subject = "A friend has recommended you a label on Stayaround.com"; $content = "Dear $fremail,

A friend has recommended the following label on stayaround.com for you:

Label: $artistname

Click here to view to the label or visit stayaround.com for further information.

Regards,
The Stayaround Team."; $result = siteMail($fremail, $subject, $content); $error1 = "Email sent to $fremail"; $fremail = ""; } } ?> LABEL PROFILE"; $temp = mysql_query("SELECT * FROM artists WHERE labelID = $id"); if (mysql_numrows($temp) > 0) echo "SIGNED ARTISTS"; echo ""; echo "
$name

"; if ($option == 1) { echo "Artists listed with $name:

"; echo ""; echo ""; $getartists = mysql_query("SELECT * FROM artists WHERE labelID=$id AND removed='0'"); if (mysql_numrows($getartists) == 0) { echo "There are no artists in the stayaround system linked to this label."; } else { $i = 1; while($row2 = mysql_fetch_array($getartists)) { if(($i % 2) == 1) $rowcolor = $contrasting_bgcolor_2; else $rowcolor = $contrasting_bgcolor_1; $i++; $gettracks = mysql_query("SELECT * FROM tracks WHERE artistID=$row2[id] AND removed='0'"); $totaltracks = mysql_numrows($gettracks); $getgenre = mysql_query("SELECT * FROM genres WHERE id=$row2[genreID]"); $genrename = mysql_result($getgenre, 0, name); $genreprefix = mysql_result($getgenre, 0, filename_prefix); $notallowed = array("[", "]", "{", "}", ",", "*", "&", "^", "%", "/", "|", ";", ":", "?", "'", "(", ")"); $arname = $row2[name]; $arname = str_replace($notallowed, "", $arname); $arname = str_replace(" ", "-", $arname); $paget = $arname; $paget = strtolower($paget); echo ""; } } $notallowed = array("[", "]", "{", "}", ",", "*", "&", "^", "%", "/", "|", ";", ":", "?", "'", "(", ")"); $arname = $name; $arname = str_replace($notallowed, "", $arname); $arname = str_replace(" ", "-", $arname); $paget = $arname; $paget = strtolower($paget); echo "
Artist Name: Genre:No. of Tracks:  
$row2[name] $genrename $totaltracks

Return to $name page
"; } else { if (strlen($profile) == 0) { $profile = "There is no profile information for this label."; } echo "
"; if ($labelimage !="0") { echo "
"; labelsImage($id, $imagewidth, 0, 0, 1); /* $imagewidth value must be quoted at top */ echo "
"; } $getartists = mysql_query("SELECT * FROM artists WHERE labelID=$id AND removed='0' LIMIT 5"); if (mysql_numrows($getartists) > 0) { echo "
"; echo "
Sample of artists signed to this label:
"; echo ""; $i = 1; while($row2 = mysql_fetch_array($getartists)) { if(($i % 2) == 1) $rowcolor = $contrasting_bgcolor_2; else $rowcolor = $contrasting_bgcolor_1; $i++; $getgenre = mysql_query("SELECT * FROM genres WHERE id=$row2[genreID]"); $genrename = mysql_result($getgenre, 0, name); $genreprefix = mysql_result($getgenre, 0, filename_prefix); $notallowed = array("[", "]", "{", "}", ",", "*", "&", "^", "%", "/", "|", ";", ":", "?", "'", "(", ")"); $arname = $row2[name]; $arname = str_replace($notallowed, "", $arname); $arname = str_replace(" ", "-", $arname); $paget = $arname; $paget = strtolower($paget); echo ""; } echo "
Artist Name: Genre:
$row2[name] $genrename
 
"; } if ($showsite == "0" AND $showemail == "0" AND $showcontact == "0") { } else{ echo "
Contact details for $name:

"; if ($showcontact == "1") { echo "$name
$address1
$address2
$city
$county
$country

"; } if ($showsite == "1") { echo "w $site
"; } if ($showemail == "1") { echo "e $email"; } echo "

"; } echo "
$profile"; } ?>
"; if (strlen($error1) > 0) echo "
".$error1."

"; echo "



"; include("footer.php"); } ?>