query("SELECT * FROM StoreSections WHERE ID = '$_sid'"); $db->next_record(); $s_name = $db->field("Name"); $db->query("SELECT Products.ID, Products.Description, Products.Tracklist, Products.Price1, Products.Price2, Products.Licensing, Products.CatalogueNumber, Products.Format, Products.ReleaseMonth, Products.ReleaseYear, Products.NumberDiscs, Products.ComingSoon, Artists.Forename, Artists.Surname, Artists.Band, Products.Title, Products.Label, Products.SectionID, Products.FullTracklist FROM Products INNER JOIN Artists ON Products.ArtistID = Artists.ID WHERE Products.ID = '$_pid' AND Products.StockLevel > '0' AND Products.Live = 'YES'"); $db->next_record(); $p_title = $db->field("Title"); $p_price = ($db->field("Licensing") == "UK") ? $db->field("Price1") : $db->field("Price2"); $p_csign = ($db->field("Licensing") == "UK") ? "£" : '$'; $p_description = str_replace("\n","
",$db->field("Description")); if ($db->field("FullTracklist") == "YES"){ $p_tracklist = ""; $db2 = db(); $db2->query("SELECT * FROM ProductsTracks WHERE ProductID = '$_pid' ORDER BY TrackNo"); while ($db2->next_record()){ $p_tracklist .= ""; } $p_tracklist .= "

".$db2->field("TrackNo").". ".$db2->field("Title")."

"; } else { $p_tracklist = str_replace("\n","
",$db->field("Tracklist")); } $p_releasedate = date("F",gmmktime(1,1,1,$db->field("ReleaseMonth"),1,1))." ".$db->field("ReleaseYear"); $p_numberdiscs = $db->field("NumberDiscs"); $p_catnumber = $db->field("CatalogueNumber"); $p_label = $db->field("Label"); $p_artist = $db->field("Band") == "" ? $db->field("Forename")." ".$db->field("Surname") : $db->field("Band"); $p_comingsoon = $db->field("ComingSoon"); $p_format = $db->field("Format"); $extratitle = " | $p_artist - $p_title"; $db->query("SELECT * FROM ProductImages WHERE ProductID = '$_pid' AND DeleteMe = 'NO' ORDER BY TypeID ASC"); while ($db->next_record()){ $_image[$db->field("TypeID")] = $db->field("Filename"); }; $mainimage = $_image[1] == "" ? " $\"$p_artist$ " : " $\"$p_artist$ "; $extraimages = $_image[2] == "" ? "" : "View Disc"; $extraimages .= ($_image[2] != "" && $_image[3] != "") ? " | " : ""; $extraimages .= $_image[3] == "" ? "" : "View Back Cover"; if ($p_description != ""){ $description = "

Item Description

$p_description

"; } $sectionurl = urlsafe("#slash#$s_name#slash#$_sid"); $producturl = urlsafe("#slash#$s_name#slash#$_sid#slash#$p_artist-$p_title#slash#$_pid"); if ($p_comingsoon == "NO"){ $pricerow = "

$p_format $p_csign$p_price

"; $addtobasket = <<
EOS; } else { $pricerow = "

Out of Stock

"; $addtobasket = ""; } $bodystring = <<« $s_name

$mainimage

$extraimages

$p_artist

$p_title

$pricerow

Release Date:

$p_releasedate

Nº of Discs:

$p_numberdiscs

Catalogue Nº

$p_catnumber

Label:

$p_label

$addtobasket

Tracklisting

$p_tracklist

$description BODY; }; include ("template.php"); ?>