<?php require_once('Connections/JCH_Sql.php'); ?>
<?php
$name_Print_Artiste = "1";
if (isset($_GET['Band_Type'])) {
  $name_Print_Artiste = (get_magic_quotes_gpc()) ? $_GET['Band_Type'] : addslashes($_GET['Band_Type']);
}
mysql_select_db($database_JCH_Sql, $JCH_Sql);
$query_Print_Artiste = sprintf("SELECT * FROM Band_List WHERE Band_Type = '%s' and Status='Available' ORDER BY Band_Name ASC", $name_Print_Artiste);
$Print_Artiste = mysql_query($query_Print_Artiste, $JCH_Sql) or die(mysql_error());
$row_Print_Artiste = mysql_fetch_assoc($Print_Artiste);
$totalRows_Print_Artiste = mysql_num_rows($Print_Artiste);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>:: J C H O N L I N E ::</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="Small%20Title.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #000000}
-->
</style>
</head>

<body>
<span class="smallnews">&lt;<a href="javascript:history.go(-1)"> Back to Artist List</a></span><br>
<?php do { ?>
    <table width="85%"  border="0" align="center" cellpadding="0" cellspacing="1">
  <tr>
    <td bgcolor="#000000" class="smallnews style4"></td>
  </tr>
</table>
<table width="100%"  border="0" align="center" cellpadding="1" cellspacing="0">
  <tr>
    <td bgcolor="#000000"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
        <tr bgcolor="#FFFFFF">
          <td width="9%" rowspan="3"><div align="center"><img src="<?php echo $row_Print_Artiste['Photo_Thum']; ?>"></div></td>
          <td class="b9"><div align="left">Band Name : <span class="smallnews style1 style2"><span class="b9"><strong><?php echo $row_Print_Artiste['Band_Name']; ?></strong></span></span></div></td>
          <td class="b9"><div align="left">Band Type : <span class="smallnews style1 style2"><span class="b9"><strong><?php echo $row_Print_Artiste['Band_Type']; ?></strong></span></span></div></td>
          <td><div align="left"><span class="b9">No. of Members : </span><span class="smallnews style1 style2"><span class="smallnews  style1 style3"><span class="b9"><?php echo $row_Print_Artiste['Members']; ?></span></span></span></div></td>
        </tr>
        <tr bgcolor="#FFFFFF">
          <td colspan="3" class="smallnews style1"><div align="justify" class="Performnce style1">
            <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr>
                <td><?php echo $row_Print_Artiste['Band_Write_Up_Small']; ?></td>
              </tr>
            </table>
            </div></td>
        </tr>
        <tr bgcolor="#FFFFFF">
          <td class="Performnce"><div align="right" class="b9"><strong>Current Performance : </strong></div></td>
          <td colspan="2"><span class="b9"><?php echo $row_Print_Artiste['Venue']; ?></span> - <span class="b9 style2"><?php echo $row_Print_Artiste['City']; ?></span>, <span class="smallnews style1"><?php echo $row_Print_Artiste['Country']; ?></span></td>
        </tr>
    </table></td>
  </tr>
</table>
<?php } while ($row_Print_Artiste = mysql_fetch_assoc($Print_Artiste)); ?>
</body>
</html>
<?php
mysql_free_result($Print_Artiste);
?>
