Editing Links

TITLE:

SLUG:

X COORDINATE:

Y COORDINATE:

<?php if ($_GET['cat'] != NULL) { // open and query database $dbConn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); mysql_select_db(DB_NAME, $dbConn); $query_section = "SELECT * FROM `section` WHERE `id` LIKE '" . $_GET['cat'] . "'"; $result_section = mysql_query($query_section); $recSection = mysql_fetch_array($result_section, MYSQL_ASSOC); print "<h1>" . $recSection["title"] . "</h1>"; print "<p align=\"center\">[<a href=\"" . $_SERVER['PHP_SELF'] . "\">Back to Links</a>]</p>"; $query_section2link = "SELECT * FROM `section2link` WHERE `section` LIKE '" . $_GET['cat'] . "'"; $result_section2link = mysql_query($query_section2link); while ($recSection2link = mysql_fetch_array($result_section2link, MYSQL_ASSOC)) { $query_link = "SELECT * FROM `link` WHERE `id` LIKE '" . $recSection2link["link"] . "'"; $result_link = mysql_query($query_link); while ($recLink = mysql_fetch_array($result_link, MYSQL_ASSOC)) { print "<p class=\"linkitem\">\n"; print "\t<strong><a href=\"" . $recLink["url"] . "\">" . $recLink["title"] . "</a></strong><br />"; print $recLink["description"] . "<br />"; print "</p>\n"; print "<hr />"; } } mysql_free_result($result_link); mysql_close($dbConn); } else { ?> <div> <h1>Links</h1> <table width="100%"> <tr> <td valign="center"> <p align="center">[photo transbayTerminal 430 link]</p> <p align="center"><strong>Postcard of the Transbay Terminal at 1st & Mission</strong></p> </td> <td valign="top"> <p align="center"><strong>CATEGORIES:</strong></p> <ul> <?php // open and query database $dbConn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); mysql_select_db(DB_NAME, $dbConn); $query_section = "SELECT * FROM `section`"; $result_section = mysql_query($query_section); while ($recSection = mysql_fetch_array($result_section, MYSQL_ASSOC)) { print "<li><a href=\"" . $_SERVER['PHP_SELF'] . "?cat=" . $recSection["id"] . "\">" . $recSection["title"] . "</a></li>"; } mysql_free_result($result_section); mysql_close($dbConn); ?> </ul> </td> </tr> </table> </div> <?php } ?>

PASSWORD: