include 'authenticate.php'; $querystr = 'SELECT CompoGames.ID, CompoEntrant.BoardName AS Entrant, CompoGames.GameName AS Game, CompoPlatform.PlatformName AS Platform, CompoGenre.GenreName AS Genre, CompoStatus.StatusPercent AS Status, CompoGames.WebPage AS Remake_URL, CompoGames.OriginalPage AS Original_URL, CompoGames.CommentsPublic AS ShowComments FROM CompoGames, CompoEntrant, CompoPlatform, CompoGenre, CompoStatus WHERE CompoGames.ID = ' . $entryID . ' AND CompoEntrant.ID = CompoGames.EntrantID AND CompoPlatform.ID = CompoGames.PlatformID AND CompoGenre.ID = CompoGames.GenreID AND CompoStatus.ID = CompoGames.StatusID'; $resultset = mysql_query($querystr, $dbconnect); if(mysql_num_rows($resultset) < 1) { include 'pageheader.php'; print 'That does not appear to be a valid entry.'; include 'pagefooter.php'; include 'dbdisconn.php'; exit(); } else { $row = mysql_fetch_row($resultset); $pagetitle = 'View Entry'; include 'pageheader.php'; print '
| ' . $columnName . ' | '; print '' . stripslashes($row[$i]) . ' | '; print '
| View/Leave Comments | |
| edit this entry | |
| delete this entry | |