0){$template = $_GET['template'];} else {$template=11;} $query = "SELECT body_id, header FROM ck_templates WHERE id = '$template'"; $result = mysql_query($query, $conn) or die(mysql_error()); mysql_select_db($database,$conn); $cd_query = "SELECT id,cd_name,synopsis,total_time,front_cover,front_caption, back_cover, back_caption,add_info FROM ck_cds WHERE id =".$_GET['id']; $cd_result = mysql_query($cd_query, $conn) or die(mysql_error()); mysql_select_db($database,$conn); $info_query = " SELECT ck_cd_info.id,ck_cd_info.cd_id,ck_cd_info.track_title,ck_cd_info.composer, ck_cd_info.grade,ck_cd_info.time, ck_presentations.cd_name, ck_cd_info.add_info, ck_presentations.instrumentation FROM ck_cd_info INNER JOIN ck_presentations ON ck_presentations.id = ck_cd_info.track_title WHERE ck_cd_info.cd_id =".$_GET['id']." ORDER BY ck_cd_info.id ASC "; $info_result = mysql_query($info_query, $conn) or die(mysql_error()); $infonums=mysql_num_rows($info_result); mysql_select_db($database,$conn); function backLink(){ if ($_GET['cat']==9){echo"music.php";} if ($_GET['cat']==1){echo"music_compositions.php";} if ($_GET['cat']==2){echo"amstel_classics.php";} if ($_GET['cat']==3){echo"music_for_theatre.php";} if ($_GET['cat']==4){echo"symphony_orchestra.php";} if ($_GET['cat']==5){echo"music_of_soren.php";} } ?>
< back
$cd_name"; echo"
"; if(strlen($_GET['category'])>0){$category = $_GET['category'];} else {$category=4;} ?>
";}else{ echo ""; } ?>

0) { echo "

 

Total Time: ".$total_time."

";} ?>
 
 
0) { ?>
0){?>
Title Composer/Arranger Time
 
"; ?>