Hi Brian,
I can't really give a public URL as it's a members section but i am emailing you with a login.
I've managed to fix it so that they can download, however for this to work they need to upload the song with exactly the same wording in the ItemName title as the wording of the PDF which while still working is not ideal as i would like for them to be able to call it whatever they like but have it still pulled from the database depending on what record they choose...Anyway, here is the page as it stands now (sorry it's pretty long!) :
<?php require_once('../../Connections/belacappella.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
?>
<?php
if (!session_id()) session_start();
?>
<?php
$ParamItemID_WADAmusicuploads = "-1";
if (isset($_GET['ItemID'])) {
$ParamItemID_WADAmusicuploads = (get_magic_quotes_gpc()) ? $_GET['ItemID'] : addslashes($_GET['ItemID']);
}
$ParamSessionItemID_WADAmusicuploads = "-1";
if (isset($_SESSION['WADA_Insert_musicuploads'])) {
$ParamSessionItemID_WADAmusicuploads = (get_magic_quotes_gpc()) ? $_SESSION['WADA_Insert_musicuploads'] : addslashes($_SESSION['WADA_Insert_musicuploads']);
}
$ParamItemID2_WADAmusicuploads = "-1";
if (isset($_GET['ItemID'])) {
$ParamItemID2_WADAmusicuploads = (get_magic_quotes_gpc()) ? $_GET['ItemID'] : addslashes($_GET['ItemID']);
}
mysql_select_db($database_belacappella, $belacappella);
$query_WADAmusicuploads = sprintf("SELECT ItemID, ItemName, ItemDescription, ItemType FROM musicuploads WHERE ItemID = %s OR ( -1= %s AND ItemID= %s)", GetSQLValueString($ParamItemID_WADAmusicuploads, "int"),GetSQLValueString($ParamItemID2_WADAmusicuploads, "int"),GetSQLValueString($ParamSessionItemID_WADAmusicuploads, "int"));
$WADAmusicuploads = mysql_query($query_WADAmusicuploads, $belacappella) or die(mysql_error());
$row_WADAmusicuploads = mysql_fetch_assoc($WADAmusicuploads);
$totalRows_WADAmusicuploads = mysql_num_rows($WADAmusicuploads);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Bel A Cappella</title>
<link href="../../styles/main.css" rel="stylesheet" type="text/css" />
<link href="../../styles/navigation.css" rel="stylesheet" type="text/css" />
<link href="../../styles/members.css" rel="stylesheet" type="text/css" />
<link href="../../WA_DataAssist/styles/Traditional_Slate.css" rel="stylesheet" type="text/css" />
<link href="../../WA_DataAssist/styles/Arial.css" rel="stylesheet" type="text/css" />
<style type="text/css">
/* Details page CSS */
.WADADetailsContainer {
font-size: 11px;
}
#WADADetails {
padding-top: 5px;
}
</style>
<!--[if IE 7]>
<link rel="stylesheet" type="text/css" href="../../styles/iestyles.css" media="all" />
<![endif]-->
<!--[if lt IE 7]>
<link rel="stylesheet" type="text/css" href="../../styles/ie7minus.css" media="all" />
<![endif]-->
<!--[if lte IE 7]>
<style type="text/css">
#menu ul {display:inline;}
#menu li a.fly:hover {background-color:#ddd; }
#menu {text-align:left; padding-top: 8px;}
</style>
<![endif]-->
</head>
<body>
<div id="wrapper">
<div id="insideWrapperTop"></div>
<div id="insideWrapperMiddle">
<div id="insideWrapperContent">
<div class="insideNavEtc">
<div id="topMainLinks">
<div id="menu">
<ul class="level1">
<li class="level1-li"><a class="level1-a" href="../../index.html">site home</a></li>
<li class="level1-li left"><a class="level1-a" href="../index.php">members home</a></li>
<li class="level1-li left"><a class="level1-a" href="index2.php">admin home</a></li>
</ul>
</div>
</div>
<div id="bannerTestimonialInside">
<h1>“What a great performance. The music was outstanding <br />
and the vocals uplifting. What a marvellous night!”</h1>
</div>
</div>
<div class="twoColLeft">
<div class="leftMemberNav">
<ul>
<li><a href="memberlogin_Insert.php">insert member user details</a></li>
<li><a href="memberlogin_Results.php">search / modify member details</a></li>
<li><a href="adminlogin_Registration.php">register admin user</a></li>
<li><a href="adminlogin_Profile.php">update admin user details</a></li>
<li><a href="musicuploads_Insert.php">upload sheetmusic</a></li>
<li><a href="musicuploads_Results.php">delete sheetmusic</a></li>
<li><a href="how_to_upload_photographs.php">upload photographs to the gallery</a></li>
<li><a href="send_newsletter.php">send a newsletter</a></li>
<li><a href="#">contact president</a></li>
</ul>
</div>
</div>
<div class="twoColRight">
<div class="insideText">
<br /> <h1>ADMIN - Show Details Of Musical Record / Sheetmusic
<a name="top"></a>
</h1>
<div class="WADADetailsContainer">
<div class="WADAHorizLine"><img src="../WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<?php if ($totalRows_WADAmusicuploads > 0) { // Show if recordset not empty ?>
<div id="WADADetails">
<div class="WADAHeader"></div>
<table class="WADADataTable" cellpadding="0" cellspacing="0" border="0">
<tr>
<th class="WADADataTableHeader">Music Name:</th>
<td class="WADADataTableCell"><?php echo($row_WADAmusicuploads['ItemName']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Music Description:</th>
<td class="WADADataTableCell"><?php echo($row_WADAmusicuploads['ItemDescription']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Music Type:</th>
<td class="WADADataTableCell"><?php echo($row_WADAmusicuploads['ItemType']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Upload Music:</th>
<td class="WADADataTableCell"><a href="../uploaded_files/<?php echo $row_WADAmusicuploads['ItemName']; ?>.pdf" target="_blank">Download PDF</a></td>
</tr>
</table>
<div class="WADAHorizLine"><img src="../WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<div class="WADAButtonRow">
<table class="WADADataNavButtons" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="WADADataNavButtonCell" nowrap="nowrap"><a href="musicuploads_Update.php?ItemID=<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" title="Update"><img border="0" name="Update" id="Update" alt="Update" src="../../WA_DataAssist/images/Slate/Traditional_update.gif" /></a></td>
<td class="WADADataNavButtonCell" nowrap="nowrap"><a href="musicuploads_Delete.php?ItemID=<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" title="Delete"><img border="0" name="Delete" id="Delete" alt="Delete" src="../../WA_DataAssist/images/Slate/Traditional_delete.gif" /></a></td>
<td class="WADADataNavButtonCell" nowrap="nowrap"><a href="musicuploads_Results.php" title="Results"><img border="0" name="Results" id="Results" alt="Results" src="../../WA_DataAssist/images/Slate/Traditional_results.gif" /></a></td>
</tr>
</table>
</div>
</div>
<?php } // Show if recordset not empty ?>
<?php if ($totalRows_WADAmusicuploads == 0) { // Show if recordset empty ?>
<div class="WADANoResults">
<div class="WADANoResultsMessage">No record found.</div>
</div>
<div class="WADAHorizLine"><img src="../WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<div class="WADADetailsLinkArea">
<div class="WADADataNavButtonCell"><a href="musicuploads_Results.php" title="Results"><img border="0" name="Results1" id="Results1" alt="Results" src="../../WA_DataAssist/images/Slate/Traditional_results.gif" /></a></div>
</div>
<div class="WADAHorizLine"><img src="../WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<?php } // Show if recordset empty ?>
</div><br />
</p>
</div>
<p> </p>
</div>
<div class="bottomSpacer"></div>
</div>
</div>
<div id="insideWrapperBottom">
<div class="insideWrapperBottomBorder"></div>
<p><a href="http://www.overloadweb.com.au" target="_blank">© 2010 Bel A Cappella :: design by Overload</a></p>
<p> </p>
<p> </p>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($WADAmusicuploads);
?>
