
$result = mysql_query("SELECT * FROM artist ORDER BY artist_order");
while ($row = mysql_fetch_array($result)){
?>
=$row['artist_name']?>
}
//Check for releasses links...
if (isset($_GET['v'])){
if (is_numeric($_GET['v'])){
$result = mysql_query("SELECT * FROM artist WHERE artist_image !='' AND artist_id=".$_GET['v']);
if (mysql_numrows($result) > 0){
$row = mysql_fetch_array($result);
list($width,$height) = getimagesize('./artist_images/'.$row['artist_image']);
?>
}
$result = mysql_query("SELECT * FROM releases_track WHERE artist_id=".$_GET['v']);
if (mysql_numrows($result) > 0){
?>

while ($row = mysql_fetch_array($result)){
?>

=$row['releases_track_artist']?>
=$row['releases_track_name']?>
}
}
}
}
?>
if (isset($_GET['v'])){
if (is_numeric($_GET['v'])){
$test = mysql_query("SELECT * FROM artist WHERE artist_id=".$_GET['v']);
if (mysql_numrows($test) == 1){
$row = mysql_fetch_array($test);
?>

=$row['artist_name']?>
if ($row['artist_about'] != ''){
?>
=nl2br($row['artist_about'])?>
}
?>
$qa_result = mysql_query("SELECT * FROM artist_q WHERE artist_id=".$row['artist_id']);
if (mysql_numrows($qa_result) > 0){
?>
![<?=$row['artist_name']?> Q&A](./images/qa.gif)
while ($qa_row = mysql_fetch_array($qa_result)){
?>
=nl2br($qa_row['artist_q_q'])?>
=nl2br($qa_row['artist_q_a'])?>
}
}
$l_result = mysql_query("SELECT * FROM artist_l WHERE artist_id=".$row['artist_id']);
while ($l_row = mysql_fetch_array($l_result)){
?>
=$l_row['artist_l_name']?>
$list = explode("\n",$l_row['artist_l_list']);
foreach ($list as $li){
?>- =$li?>
}
?>
}
$d_result = mysql_query("SELECT * FROM artist_d WHERE artist_id=".$row['artist_id']." ORDER BY artist_d_cat,artist_d_name");
if (mysql_numrows($d_result) > 0){
?>
$last_cat='';
while ($d_row = mysql_fetch_array($d_result)){
if ($d_row['artist_d_cat'] != $last_cat){
?> =$d_row['artist_d_cat']?> | Label |
}
?>| =$d_row['artist_d_name']?> | =$d_row['artist_d_type']?> | =$d_row['artist_d_label']?> |
$last_cat = $d_row['artist_d_cat'];
}
?>
}
}
}
}
?>