J C H O N L I N E | Artiste Details Page

0) { $pwf_message = "The image code you have provided does not match the actual one. Hit the 'back' button of your browser and input the correct code please."; if(strlen($_POST['protectwebformcode']) > 30) { die($pwf_message); } $protectwebformresult = @file_get_contents( "http://protectwebform.com/verify01?vui=3214&vp=w47sxgr156dq&ri=" . urlencode($_SERVER['REMOTE_ADDR']) . "&vs=" . urlencode($_POST['protectwebformcode'])); if(preg_match("||", $protectwebformresult)) { die($pwf_message); } } // End of code provided by http://www.protectwebform.com function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } // configure to fit your needs $to = "magendran.adeyah@gmail.com"; $toname = "Webmaster"; $subject = "Guest Comments to Artiste"; // for Drupal users modify the form tag the same as the alias line in the page // do not modify below this line if (isset($_POST['MM_insert'])) { $from = $_POST['email']; $fromname = $_POST['name']; $fArtist = $_POST['hiddenBand']; $fdate = $_POST['Date']; $message = $_POST['comment']; // extra info to add to message $address = gethostbyaddr($_SERVER['REMOTE_ADDR']); $ip = gethostbyname($_SERVER['REMOTE_ADDR']); $timestamp = time (); $filename = $_SERVER['PHP_SELF']; $location = $_SERVER['SERVER_NAME']; // adding $messagewithinfo = "Artist Name = $fArtist \n Name = $fromname <$from> \n Date = $fdate \n Wrote = \n $message \n Extra info: \n IP = $ip \n Address = $address \n Time at server = $timestamp \n Sent with this page = $locationn"; mail($to, $subject, $messagewithinfo, "From: $fromname <$from>\n" . "Reply-To: $from \n" . "X-Mailer: PHP/" . phpversion()); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "Guestbook")) { $insertSQL = sprintf("INSERT INTO Guestbook (band, bandURL, name, email, comment, datetime) VALUES (%s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['hiddenBand'], "text"), GetSQLValueString($_POST['hiddenBandURL'], "text"), GetSQLValueString($_POST['name'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['comment'], "text"), GetSQLValueString($_POST['Date'], "text")); mysql_select_db($database_JCH_Sql, $JCH_Sql); $Result1 = mysql_query($insertSQL, $JCH_Sql) or die(mysql_error()); } $colname_Artiste_Band_Details = "-1"; if (isset($_GET['BandName'])) { $colname_Artiste_Band_Details = (get_magic_quotes_gpc()) ? $_GET['BandName'] : addslashes($_GET['BandName']); } mysql_select_db($database_JCH_Sql, $JCH_Sql); $query_Artiste_Band_Details = sprintf("SELECT * FROM Band_List WHERE URL_Safe_Name = '%s' ORDER BY Band_Name ASC", $colname_Artiste_Band_Details); $Artiste_Band_Details = mysql_query($query_Artiste_Band_Details, $JCH_Sql) or die(mysql_error()); $row_Artiste_Band_Details = mysql_fetch_assoc($Artiste_Band_Details); $totalRows_Artiste_Band_Details = mysql_num_rows($Artiste_Band_Details); $VarBandName_Artiste_Member_Details = "1"; if (isset($_GET['BandName'])) { $VarBandName_Artiste_Member_Details = (get_magic_quotes_gpc()) ? $_GET['BandName'] : addslashes($_GET['BandName']); } mysql_select_db($database_JCH_Sql, $JCH_Sql); $query_Artiste_Member_Details = sprintf("SELECT * FROM Band_Members WHERE Status = 'Available' AND SafeName = '%s'", $VarBandName_Artiste_Member_Details); $Artiste_Member_Details = mysql_query($query_Artiste_Member_Details, $JCH_Sql) or die(mysql_error()); $row_Artiste_Member_Details = mysql_fetch_assoc($Artiste_Member_Details); $totalRows_Artiste_Member_Details = mysql_num_rows($Artiste_Member_Details); $colname_PerformanceRecord = "1"; if (isset($_GET['BandName'])) { $colname_PerformanceRecord = (get_magic_quotes_gpc()) ? $_GET['BandName'] : addslashes($_GET['BandName']); } mysql_select_db($database_JCH_Sql, $JCH_Sql); $query_PerformanceRecord = sprintf("SELECT * FROM PerformanceRecord WHERE `BAND NAME` = '%s'", $colname_PerformanceRecord); $PerformanceRecord = mysql_query($query_PerformanceRecord, $JCH_Sql) or die(mysql_error()); $row_PerformanceRecord = mysql_fetch_assoc($PerformanceRecord); $totalRows_PerformanceRecord = mysql_num_rows($PerformanceRecord); $maxRows_Guestbook = 3; $pageNum_Guestbook = 0; if (isset($_GET['pageNum_Guestbook'])) { $pageNum_Guestbook = $_GET['pageNum_Guestbook']; } $startRow_Guestbook = $pageNum_Guestbook * $maxRows_Guestbook; $colname_Guestbook = "-1"; if (isset($_GET['BandName'])) { $colname_Guestbook = (get_magic_quotes_gpc()) ? $_GET['BandName'] : addslashes($_GET['BandName']); } mysql_select_db($database_JCH_Sql, $JCH_Sql); $query_Guestbook = sprintf("SELECT * FROM Guestbook WHERE bandURL = '%s' AND YesNo = '1' ORDER BY Id DESC", $colname_Guestbook); $query_limit_Guestbook = sprintf("%s LIMIT %d, %d", $query_Guestbook, $startRow_Guestbook, $maxRows_Guestbook); $Guestbook = mysql_query($query_limit_Guestbook, $JCH_Sql) or die(mysql_error()); $row_Guestbook = mysql_fetch_assoc($Guestbook); if (isset($_GET['totalRows_Guestbook'])) { $totalRows_Guestbook = $_GET['totalRows_Guestbook']; } else { $all_Guestbook = mysql_query($query_Guestbook); $totalRows_Guestbook = mysql_num_rows($all_Guestbook); } $totalPages_Guestbook = ceil($totalRows_Guestbook/$maxRows_Guestbook)-1; $colname_GuestReview = "-1"; if (isset($_GET['BandName'])) { $colname_GuestReview = (get_magic_quotes_gpc()) ? $_GET['BandName'] : addslashes($_GET['BandName']); } mysql_select_db($database_JCH_Sql, $JCH_Sql); $query_GuestReview = sprintf("SELECT * FROM Guestbook WHERE bandURL = '%s' AND YesNo = '0'", $colname_GuestReview); $GuestReview = mysql_query($query_GuestReview, $JCH_Sql) or die(mysql_error()); $row_GuestReview = mysql_fetch_assoc($GuestReview); $totalRows_GuestReview = mysql_num_rows($GuestReview); $colname_RSVideo = "-1"; if (isset($_GET['BandName'])) { $colname_RSVideo = (get_magic_quotes_gpc()) ? $_GET['BandName'] : addslashes($_GET['BandName']); } mysql_select_db($database_JCH_Sql, $JCH_Sql); $query_RSVideo = sprintf("SELECT * FROM Band_List WHERE URL_Safe_Name = '%s' AND VideoYN = '1'", $colname_RSVideo); $RSVideo = mysql_query($query_RSVideo, $JCH_Sql) or die(mysql_error()); $row_RSVideo = mysql_fetch_assoc($RSVideo); $totalRows_RSVideo = mysql_num_rows($RSVideo); $colname_CheckGuestBook = "-1"; if (isset($_GET['BandName'])) { $colname_CheckGuestBook = (get_magic_quotes_gpc()) ? $_GET['BandName'] : addslashes($_GET['BandName']); } mysql_select_db($database_JCH_Sql, $JCH_Sql); $query_CheckGuestBook = sprintf("SELECT * FROM Guestbook WHERE bandURL = '%s' ", $colname_CheckGuestBook); $CheckGuestBook = mysql_query($query_CheckGuestBook, $JCH_Sql) or die(mysql_error()); $row_CheckGuestBook = mysql_fetch_assoc($CheckGuestBook); $totalRows_CheckGuestBook = mysql_num_rows($CheckGuestBook); $colname_Available = "-1"; if (isset($_GET['BandName'])) { $colname_Available = (get_magic_quotes_gpc()) ? $_GET['BandName'] : addslashes($_GET['BandName']); } mysql_select_db($database_JCH_Sql, $JCH_Sql); $query_Available = sprintf("SELECT * FROM Band_List WHERE URL_Safe_Name = '%s' AND End_Year = '0'", $colname_Available); $Available = mysql_query($query_Available, $JCH_Sql) or die(mysql_error()); $row_Available = mysql_fetch_assoc($Available); $totalRows_Available = mysql_num_rows($Available); ?> J C H O N L I N E | Artiste Details Page

Click to view bigger photo..

' , $row['']); //this is how to break a line. ?>

Band Category	:	.

Currently perform at	:	, , . From - - to - - .
Download ="1") {?>
This band is available for booking. Contact us now for more information.