Dynamic links
I have a recordset which displays in a dynamic table showing columns for Title, Series, Author and Date. The recordset also contains a field File_location which contains references to PDF files (ie the filename xxxx.pdf). I want to display this recordset in such a way that when the Title is clicked, it opens up the PDF file. Can't work out how to configure the a href.....
<?php do { ?>
<tr>
<td><?php echo $row_RSnotes['title']; ?></td>
<td><?php echo $row_RSnotes['series']; ?></td>
<td> <?php echo $row_RSnotes['author_firstname']; ?> <?php echo $row_RSnotes['author_lastname']; ?></td>
<td><?php echo $row_RSnotes['date']; ?></td>
</tr>
<?php } while ($row_RSnotes = mysql_fetch_assoc($RSnotes)); ?>
