MS Access Page Link/Refresh

[contraboybish]

I hope i ask this question properly.

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.....

 

                        <?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); 

?>

 

I hope somebody can get me started :-)

 

Bish