Page 1 of 1

MS Access Page Link/Refresh

Posted: Sat Nov 28, 2009 3:41 pm
by bishmedia
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.....

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);   
                  ?>
I hope somebody can get me started :-)

Bish