No record ID given!"; include "footer.inc"; exit; } mysql_connect($hostname,$user,$pass); mysql_select_db($dbname); $query = "select * from $album_table where id = '$id'"; $result = mysql_db_query($dbname, $query); if ($result) { $num_rows = @mysql_num_rows($result); if ($num_rows < 1) { echo "
No record found!"; include "footer.inc"; exit; } echo "
[back]
"; $row = mysql_fetch_array($result); echo "\n"; echo "\n"; echo "\n"; } echo "\n"; echo "
\n"; // get image if exist: $img_file = "image/scherb_" .$id .".jpg"; $img_file_b = "image/scherb_" .$id ."_b.jpg"; $big_img_file = "image/scherb_" .$id ."_l.jpg"; $big_img_file_b = "image/scherb_" .$id ."_l_b.jpg"; $no_img_file = "image/scherb_0.jpg"; if (file_exists($img_file)) { if (file_exists($big_img_file)) { echo ""; echo ""; echo ""; } else { echo ""; } } else { echo ""; } if (file_exists($img_file_b)) { echo "\n"; if (file_exists($big_img_file_b)) { echo ""; echo ""; echo ""; } else { echo ""; } echo "
\n"; echo "\n"; echo ""; echo "\n"; echo "
\n"; echo "

"; $titl = $row['title']; echo "Record title: "; echo $titl ."
"; $lbl_name=""; $lbl_id = $row['label_id']; $sql = "SELECT name FROM $label_table where id ='$lbl_id'"; $res = mysql_db_query($dbname,$sql); if ($res) { $rw = mysql_fetch_row($res); $lbl_name=$rw[0]; } echo "Record label: "; echo $lbl_name; $lbl_num = $row['label_number']; echo " / "; echo $lbl_num ."
"; $medium = $row['medium']; if ($medium == '1') { $medium_txt = 'CD'; } elseif ($medium == '2') { $medium_txt = 'LP'; } elseif ($medium == '3') { $medium_txt = 'MC'; } elseif ($medium == '4') { $medium_txt = 'DVD'; } else { $medium_txt = ''; } echo "Medium: "; echo $medium_txt ."
"; $year = $row['year']; echo "Year recorded: "; echo $year ."
"; $perf = $row['performer']; $perf = html_filter_out($perf); echo "
Additional performer(s):
"; echo $perf ."
"; $cond = $row['conductor']; $cond = html_filter_out($cond); echo "Conductor(s):
"; echo $cond ."
"; $orch = $row['orchestra']; $orch = html_filter_out($orch); echo "Orchestra(s):
"; echo $orch ."
"; $comp = $row['composer']; $comp = html_filter_out($comp); echo "Composer(s):
"; echo $comp ."
"; $tl = $row['track_listing']; $tl = html_filter_out($tl); echo "Track listing: "; echo "
" .$tl ."
"; $comm = $row['comment']; $comm = html_filter_out($comm); echo "Comment: "; echo "
" .$comm ."
"; echo "
\n"; } ?>