I have a website which links to an MS Access DB, each time a user clicks the url it takes them to the Exhibition page URL that was clicked
What l would like to do is have the link click through to the page that it is already on clear the list and replace with data from another field so that l dont have to build a new page everytime but just include it in the DB, hope this makes sense.....
Code: Select all
<?php require_once('../App_Data/odbc_open.php');
$query = odbc_exec($odbc, "SELECT * FROM ExhibitionsPage WHERE exhibitionmain='yes' ORDER BY ExhibitionShortDate ASC") or die (odbc_errormsg());
while($row = odbc_fetch_array($query))
{
echo '<tr style="text-align:justify">';
echo '<td valign="top">';
echo '<div><a href="'.$row['exhibitionInternalURL'].'" class="smallLinks" >'.$row['exhibitionsDate'].'</a><br /></div>';
echo '<div class="style2" style="text-align:justify">'.$row['exhibitionrtfsmall'].'<br /></div>';
echo '<br />';
echo '</td>';
echo '</tr>';
}
odbc_close($odbc);
?>Bish