include("head.php3"); include("header.html"); if ($RowID=="") { include("header.html"); ECHO "
| "; ECHO "PLEASE SELECT FROM THE DROP DOWN AND CLICK SUBMIT ONCE AGAIN"; ECHO " | \n"; ECHO "
\n"; include("footer.html"); } else { /* make connection to database */ MYSQL_CONNECT($Host, $UserID, $UserPass) OR DIE("Unable to connect to database"); /* select the database */ @mysql_select_db($DBName) or die( "Unable to select database"); /* Select all users */ $query = "SELECT * FROM post where RowID=$RowID"; $result = MYSQL_QUERY($query); /* How many of these users are there? */ IF (MYSQL_NUMROWS($result) != 0) : $number = MYSQL_NUMROWS($result); ELSE : $number=0; ENDIF; /* Print these results to the screen in a nice format */ $i = 0; IF ($number == 0) : ECHO "PLEASE SELECT FROM THE DROP DOWN AND CLICK SUBMIT ONCE AGAIN"; ELSEIF ($number > 0) : WHILE ($i < $number): $RowID = mysql_result($result,$i,"RowID"); $Author = mysql_result($result,$i,"Author"); $Subject = mysql_result($result,$i,"Subject"); $Images = mysql_result($result,$i,"Images"); $Article = mysql_result($result,$i,"Article"); $Email = mysql_result($result,$i,"Email"); $DateEntered = mysql_result($result,$i,"DateEntered"); $Author = stripslashes("$Author"); $Subject = stripslashes("$Subject"); $Article = stripslashes("$Article"); $Email = stripslashes("$Email"); $Article = ereg_replace("\r\n", "
", $Article);
$Article = ereg_replace("\n", "
", $Article);
$i++;
ENDWHILE;
ENDIF;
mysql_free_result ($result);
}
include("post-template.php3");
include("footer.html");
?>