$username="slug_php"; $password="w5k1s9j5r2e1j"; $database="slug_site";
mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die("Unable to select database");

// Check for the GET vars
if($_GET['artistID']){ $artistID = $_GET['artistID']; } else { die('No artist selected to view...'); }

// Get the details from the database
$query = "SELECT * FROM artists WHERE artistID='$artistID'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$views = $row['views'];
$forename = $row['forename'];
$surname = $row['surname'];
$site = $row['site'];
$alias = $row['alias'];
$artist_copyright = $row['copyright'];
$defaultimg = $row['defaultimg'];
if(!$defaultimg){ $defaultimg = 1; }
if(!$_GET['imgID']){ $img = $defaultimg; } else { $img = $_GET['imgID']; }

// Get the details about default image
$query = "SELECT * FROM images WHERE artistID='$artistID' AND imgID='$img'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$img_name = $row['imgname'];
$img_fullpath = $row['fullpath'];
$img_thumbpath = $row['thumbpath'];
$img_copyright = $row['imgcopyright'];

// Get the details about other images
$query = "SELECT * FROM images WHERE artistID='$artistID' AND imgID='$defaultimg'";
$result = mysql_query($query);
$num = mysql_num_rows($result);

$i=0;
while($i < 11){

$query = "SELECT * FROM images WHERE artistID='$artistID' AND imgID='$i'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);


			if($i == 1){ $img1_name = $row['imgname']; $img1_fullpath = $row['fullpath']; $img1_thumbpath = $row['thumbpath']; $img1_copyright = $row['imgcopyright']; }
			if($i == 2){ $img2_name = $row['imgname']; $img2_fullpath = $row['fullpath']; $img2_thumbpath = $row['thumbpath']; $img2_copyright = $row['imgcopyright']; }
			if($i == 3){ $img3_name = $row['imgname']; $img3_fullpath = $row['fullpath']; $img3_thumbpath = $row['thumbpath']; $img3_copyright = $row['imgcopyright']; }
			if($i == 4){ $img4_name = $row['imgname']; $img4_fullpath = $row['fullpath']; $img4_thumbpath = $row['thumbpath']; $img4_copyright = $row['imgcopyright']; }
			if($i == 5){ $img5_name = $row['imgname']; $img5_fullpath = $row['fullpath']; $img5_thumbpath = $row['thumbpath']; $img5_copyright = $row['imgcopyright']; }
		    if($i == 6){ $img6_name = $row['imgname']; $img6_fullpath = $row['fullpath']; $img6_thumbpath = $row['thumbpath']; $img6_copyright = $row['imgcopyright']; }
			if($i == 7){ $img7_name = $row['imgname']; $img7_fullpath = $row['fullpath']; $img7_thumbpath = $row['thumbpath']; $img7_copyright = $row['imgcopyright']; }
			if($i == 8){ $img7_name = $row['imgname']; $img8_fullpath = $row['fullpath']; $img8_thumbpath = $row['thumbpath']; $img8_copyright = $row['imgcopyright']; }
			if($i == 9){ $img8_name = $row['imgname']; $img9_fullpath = $row['fullpath']; $img9_thumbpath = $row['thumbpath']; $img9_copyright = $row['imgcopyright']; }
			if($i == 10){ $img10_name = $row['imgname']; $img10_fullpath = $row['fullpath']; $img10_thumbpath = $row['thumbpath']; $img10_copyright = $row['imgcopyright']; }
$i++;
}

// Echo page
echo('<table width="104%"  border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td background="cellbg.gif" bgcolor="#000000" class="sideHeaderTop mainCell"><div align="left" class="style5"></div>            </td>
        </tr>
        <tr>
          <td valign="top" bgcolor="#FFFFFF" class="mainCell"><table width="100%"  border="0" cellspacing="0" cellpadding="10">
            <tr>
    <td width="73%" height="84" align="center" valign="top" bgcolor="#FFFFFF"><h1 align="left" class="style50 style7">forename surename &quot;site &quot;  </h1>
      <h1 align="left" class="style50 style7">&nbsp;</h1>
      '); } echo('</td>
            <td width="27%" rowspan="2" align="center" valign="top" bgcolor="#000000"><img src="../../volkan_baga/4.jpg" width="250" height="150"></td>
            </tr>
            <tr>
              <td height="39" align="center" valign="top" bgcolor="#FFFFFF">data</td>
            </tr>
          </table>            
          <div align="left">
          </div></td>
        </tr>
      </table>
');

?>