<?php require_once('Connections/JCH_Sql.php'); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="Images/style.css" rel="stylesheet" type="text/css" />
</head>

<body>
<table width="180" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#F7F7F7">
  <tr>
    <td bgcolor="F0F0F0" class="SmallTitle2"><table width="180" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="20">&nbsp;</td>
        <td width="161" class="SmallTitle2">Artiste</td>
        <td width="3">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td align="center"><table border="0" cellpadding="0" cellspacing="0" bgcolor="#F0F0F0">
      <tr>
        <td class="default">
		<?
mysql_select_db ($database_JCH_Sql, $JCH_Sql);// Connect to the database
$num_displayed = 1 ;// 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
while ($row = mysql_fetch_assoc($result))

// Display them to the screen...
{
echo "<center><a href=\"ArtistePage.php?BandName=" . $row["URL_Safe_Name"] . "\">
<img src=\"" . $row["Photo_Thum"] . "\" border=0 alt=\"" . $row["Band_Name"] ."\">
</a></center>" ;
echo "<b>Band Name: </b></font><a href=\"ArtistePage.php?BandName=" . $row["Band_Name"] . "\">".$row["Band_Name"]."</a>";
echo "<br><b>Band Type: </b><a href=\"Artiste_Go.php?BandType=" . $row["Band_Type"] . "\">".$row["Band_Type"]."</a>";
}
?>
              </span></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>
