title: Dynamically Link to PDF
body: <p>I am trying to make a link to a pdf that is located within my file system via a recordset.  The file name is inside a column called 'file'.</p>
  
  <p>Cant figure out what I'm doing wrong:</p>
  
  <pre><code> &lt;form method="POST" enctype="multipart/form-data" name="compTime" class="equipmenttroublereportSubmit" id="compTime"&gt;
  &lt;table cellpadding="4"&gt;
  &lt;tr&gt;
    &lt;td&gt;id&lt;/td&gt;
    &lt;td&gt;uploaddate&lt;/td&gt;
    &lt;td&gt;schedulemonth&lt;/td&gt;
    &lt;td&gt;version&lt;/td&gt;
    &lt;td&gt;comments&lt;/td&gt;
    &lt;td&gt;file&lt;/td&gt;
  &lt;/tr&gt;
  &lt;?php do { ?&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;?php echo $row_Recordset1['id']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_Recordset1['uploaddate']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_Recordset1['schedulemonth']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_Recordset1['version']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_Recordset1['comments']; ?&gt;&lt;/td&gt;
    &lt;td&gt;echo '&lt;a href="/_NewSite/Schedules' . $row_recordsetName['file'] . '"&gt;' . $row_recordsetName['file'] .'&lt;/a&gt;';&lt;/td&gt;
  &lt;/tr&gt;
  &lt;?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?&gt;
  &lt;/table&gt;
   &lt;p class="compTimeForm"&gt;&amp;nbsp;&lt;/p&gt;
  &lt;div align="center"&gt;&lt;/div&gt;
  &lt;/form&gt;
  </code></pre>