<?php require_once('Connections/JCH_Sql.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Artiste_Band_Details = 5;
$pageNum_Artiste_Band_Details = 0;
if (isset($_GET['pageNum_Artiste_Band_Details'])) {
  $pageNum_Artiste_Band_Details = $_GET['pageNum_Artiste_Band_Details'];
}
$startRow_Artiste_Band_Details = $pageNum_Artiste_Band_Details * $maxRows_Artiste_Band_Details;

$colname_Artiste_Band_Details = "1";
if (isset($_GET[BandType])) {
  $colname_Artiste_Band_Details = (get_magic_quotes_gpc()) ? $_GET[BandType] : addslashes($_GET[BandType]);
}
mysql_select_db($database_JCH_Sql, $JCH_Sql);
$query_Artiste_Band_Details = sprintf("SELECT * FROM Band_List WHERE Band_Type = '%s' AND Status = 'Available' ORDER BY Band_List.Band_Name ASC", $colname_Artiste_Band_Details);
$query_limit_Artiste_Band_Details = sprintf("%s LIMIT %d, %d", $query_Artiste_Band_Details, $startRow_Artiste_Band_Details, $maxRows_Artiste_Band_Details);
$Artiste_Band_Details = mysql_query($query_limit_Artiste_Band_Details, $JCH_Sql) or die(mysql_error());
$row_Artiste_Band_Details = mysql_fetch_assoc($Artiste_Band_Details);

if (isset($_GET['totalRows_Artiste_Band_Details'])) {
  $totalRows_Artiste_Band_Details = $_GET['totalRows_Artiste_Band_Details'];
} else {
  $all_Artiste_Band_Details = mysql_query($query_Artiste_Band_Details);
  $totalRows_Artiste_Band_Details = mysql_num_rows($all_Artiste_Band_Details);
}
$totalPages_Artiste_Band_Details = ceil($totalRows_Artiste_Band_Details/$maxRows_Artiste_Band_Details)-1;

$queryString_Artiste_Band_Details = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Artiste_Band_Details") == false && 
        stristr($param, "totalRows_Artiste_Band_Details") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Artiste_Band_Details = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Artiste_Band_Details = sprintf("&totalRows_Artiste_Band_Details=%d%s", $totalRows_Artiste_Band_Details, $queryString_Artiste_Band_Details);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>J C H O N L I N E | Artiste List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="Images/style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
	background-image: url(Images/bg.jpg);
	background-color: #FFFFFF;
}
-->
</style></head>
<body>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
	<td align="center"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="800" height="150">
      <param name="movie" value="Images/extras/banner2.swf">
      <param name="quality" value="high">
      <embed src="Images/extras/banner2.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="800" height="150"></embed>
    </object></td>
</tr>
<tr>
  <td><table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td width="93" valign="middle" class="default">&nbsp;</td>
      <td width="707" height="25" align="center" class="default">&nbsp;</td>
    </tr>
  </table></td>
</tr>
<tr>
	<td align="center"><table width="100%" border="0" cellpadding="0" cellspacing="0">
       <tr>
        <td width="201" align="left" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
          <tr>
            <td align="center"><table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td height="25" align="center" bgcolor="#CCCCCC"><p class="SmallTitle2">                  Browse Our Random Artistes</p>                    </td>
              </tr>
              <tr>
                <td align="center" bgcolor="#FFFFFF"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="10" align="left"><p>&nbsp;</p></td>
                    <td width="185" align="left"><span class="defaultWhite">
                      <?php
mysql_select_db ($database_JCH_Sql, $JCH_Sql);// Connect to the database
$num_displayed = 10 ;// Edit this number to however many links you want displaying
$result = mysql_query ("SELECT *FROM Band_Members links ORDER BY RAND() LIMIT $num_displayed");// Select random rows from the database
// For all the rows that you selected
while ($row = mysql_fetch_array($result))

// Display them to the screen...
{
echo "<a href=\"ArtistePage.php?BandName=" . $row["SafeName"] . "\">
".$row["Member_Name"] ."
</a><br>" ;
}
?>
                    </span></td>
                  </tr>
                </table></td>
              </tr>
              <tr>
                <td align="center" bgcolor="#F7F7F7">&nbsp;</td>
              </tr>
              <tr>
                <td align="center" bgcolor="#F7F7F7"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#F0F0F0">
                  <tr>
                    <td height="25" align="center" bgcolor="#CCCCCC"><p class="SmallTitle2">Random Bands </p></td>
                  </tr>
                  <tr>
                    <td align="center" bgcolor="#F7F7F7"><p><span class="default">
                        <?php
mysql_select_db ($database_JCH_Sql, $JCH_Sql);// Connect to the database
$num_displayed = 3 ;// Edit this number to however many links you want displaying
$result = mysql_query ("SELECT * FROM Band_List links ORDER BY RAND() LIMIT $num_displayed");// Select random rows from the database
// For all the rows that you selected
while ($row = mysql_fetch_array($result))

// Display them to the screen...
{
echo "<hr width=160><a href=\"ArtistePage.php?BandName=" . $row["URL_Safe_Name"] . "\">
<img src=\"" . $row["Photo_Thum"] . "\" border=0 alt=\"" . $row["Band_Name"] ."\">
</a><br>" ;
echo $row["Band_Name"];
}
?>
                    </span></p></td>
                  </tr>
                </table></td>
              </tr>
              
            </table>              </td>
          </tr>
          
        </table>
          <p>&nbsp;</p>          </td>
        <td width="563" align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td align="center" bgcolor="#FFFFFF"><span class="Header1"><br>
                List of <?php echo $row_Artiste_Band_Details['Band_Type']; ?></span></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td colspan="2"><?php do { ?>
                  <table width="390" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr>
                      <td><table width="555" border="0" cellpadding="0" cellspacing="0">
                          <tr>
                            <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td width="4%" background="Images/extras/greyBG.gif"><img src="Images/extras/greyL.gif" width="20" height="25"></td>
                                <td width="92%" background="Images/extras/greyBG.gif"><span class="SmallTitle"><?php echo $row_Artiste_Band_Details['Band_Name']; ?></span></td>
                                <td width="4%" align="right" background="Images/extras/greyBG.gif"><img src="Images/extras/greyR.gif" width="20" height="25"></td>
                              </tr>
                            </table></td>
                            </tr>
                          <tr>
                            <td class="default"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                  <td width="33%" bgcolor="#F0F0F0"><table width="177" height="127" border="0" cellpadding="0" cellspacing="1" bgcolor="#330000">
                                      <tr>
                                        <td align="center" valign="middle"><a href="ArtistePage.php?BandName=<?php echo $row_Artiste_Band_Details['URL_Safe_Name']; ?>"><img src="<?php echo $row_Artiste_Band_Details['Photo_Thum']; ?>" border="0"></a></td>
                                      </tr>
                                  </table></td>
                                  <td width="67%" bgcolor="#F0F0F0"><table width="100%" border="0" cellpadding="5" cellspacing="0">
                                      <tr>
                                        <td class="default"><strong>Currently perform at: <br>
                                        </strong><?php echo $row_Artiste_Band_Details['Venue']; ?>,
                                        <?php echo $row_Artiste_Band_Details['City']; ?>,<br>
                                        <?php echo $row_Artiste_Band_Details['Country']; ?>.<br></td>
                                      </tr>
                                      <tr>
                                        <td class="default"><strong class="SmallTitle2">About the Artiste: </strong><br>
                                          <?php echo $row_Artiste_Band_Details['Band_Write_Up_Small']; ?>....</td>
                                      </tr>
                                      
                                  </table></td>
                                </tr>
                            </table></td>
                          </tr>
                          
                          <tr>
                            <td><a href="ArtistePage.php?BandName=<?php echo $row_Artiste_Band_Details['URL_Safe_Name']; ?>"><img src="Images/leftBtmRead.gif" width="555" height="20" border="0"></a></td>
                          </tr>
                      </table></td>
                    </tr>
                    <tr>
                      <td>&nbsp;</td>
                    </tr>
                  </table>
                <?php } while ($row_Artiste_Band_Details = mysql_fetch_assoc($Artiste_Band_Details)); ?></td>
            </tr>
            <tr>
              <td height="15" colspan="2"><p align="center" class="default"> Records <?php echo ($startRow_Artiste_Band_Details + 1) ?> to <?php echo min($startRow_Artiste_Band_Details + $maxRows_Artiste_Band_Details, $totalRows_Artiste_Band_Details) ?> of <?php echo $totalRows_Artiste_Band_Details ?>
                  .
                <table border="0" width="82%" align="center">
                    <tr>
                      <td width="23%" align="center" class="SmallTitle2"><?php if ($pageNum_Artiste_Band_Details > 0) { // Show if not first page ?>
                          <a href="<?php printf("%s?pageNum_Artiste_Band_Details=%d%s", $currentPage, 0, $queryString_Artiste_Band_Details); ?>">|&lt; First</a>
                          <?php } // Show if not first page ?></td>
                      <td width="31%" align="center" class="SmallTitle2"><?php if ($pageNum_Artiste_Band_Details > 0) { // Show if not first page ?>
                          <a href="<?php printf("%s?pageNum_Artiste_Band_Details=%d%s", $currentPage, max(0, $pageNum_Artiste_Band_Details - 1), $queryString_Artiste_Band_Details); ?>">Previous &lt;&lt;</a>
                          <?php } // Show if not first page ?></td>
                      <td width="23%" align="center" class="SmallTitle2"><?php if ($pageNum_Artiste_Band_Details < $totalPages_Artiste_Band_Details) { // Show if not last page ?>
                          <a href="<?php printf("%s?pageNum_Artiste_Band_Details=%d%s", $currentPage, min($totalPages_Artiste_Band_Details, $pageNum_Artiste_Band_Details + 1), $queryString_Artiste_Band_Details); ?>">&gt;&gt; Next</a>
                          <?php } // Show if not last page ?></td>
                      <td width="23%" align="center" class="SmallTitle2"><?php if ($pageNum_Artiste_Band_Details < $totalPages_Artiste_Band_Details) { // Show if not last page ?>
                          <a href="<?php printf("%s?pageNum_Artiste_Band_Details=%d%s", $currentPage, $totalPages_Artiste_Band_Details, $queryString_Artiste_Band_Details); ?>">Last &gt;|</a>
                          <?php } // Show if not last page ?></td>
                    </tr>
                </table></td>
            </tr>
            <tr>
              <td height="15" colspan="2">&nbsp;</td>
            </tr>
            <tr>
              <td height="15" colspan="2"><div align="center"><span class="Header1">
                <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="370" height="200">
                  <param name="movie" value="Images/extras/promo.swf">
                  <param name="quality" value="high">
                  <embed src="Images/extras/promo.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="370" height="200"></embed>
                </object>
              </span></div></td>
            </tr>
            <tr>
              <td height="15" colspan="2">&nbsp;</td>
            </tr>
          </table>          
          <p class="SmallTitle"></td>
        </tr>
    </table></td>
</tr>

<tr>
	<td class="default"><div align="center"><a href="print_Artiste.php?BandType= echo $row_Artiste_Band_Details['Band_Type']"><img src="Images/extras/print.gif" width="49" height="49" border="0"></a></div></td>
</tr>
<tr>
  <td bgcolor="#FFFFFF"><!--DWLayoutEmptyCell-->&nbsp;</td>
</tr>
<tr>
  <td background="Images/bgRB.gif" bgcolor="#000000"><div align="center"><span class="footer">| &copy; Copyright   1998 - 2006 John Chacko Holdings Sdn. Bhd. | Last Updated on
    <!-- #BeginDate format:Am1m -->November 1, 2006  13:04<!-- #EndDate -->
    |</span></div></td>
</tr>
</table>

</body>
</html>
<?php
mysql_free_result($Artiste_Band_Details);
?>