require_once("../include/config.php");?>
session_start();
$conn = mysql_connect($server, $user, $pass);
mysql_select_db($database);
$category = "UNKNOWN";
if (isset($cid))
{
$strSQL = "SELECT CategoryName FROM MessageCategories WHERE CategoryID = $cid";
$rs = mysql_query($strSQL);
$row = mysql_fetch_array($rs);
$category = $row["CategoryName"];
}
else $cid = 0;
if (session_is_registered("uid") && ($utype < 2))
if (isset($op))
{
$strSQL = "DELETE FROM Messages WHERE MessageID = $mid";
mysql_query($strSQL);
header("Location: viewmessages.php?cid=$cid&page=$page&".SID);
exit;
}
if (!isset($page)) $page = 1;
$strSQL = "SELECT COUNT(MessageID) AS NrPages FROM Messages WHERE CategoryID = $cid ORDER BY DateCreated DESC";
$rs = mysql_query($strSQL);
$row = mysql_fetch_array($rs);
$pages = floor($row["NrPages"]/$count)+1;
if ((($pages-1)*$count) == $row["NrPages"]) $pages--;
$strSQL = "SELECT MessageID, Name, Email, Url, Location, Comment, DateCreated FROM Messages WHERE CategoryID = $cid ORDER BY DateCreated DESC LIMIT ".(($page-1)*$count).", $count";
if ($pages > 0) $rs = mysql_query($strSQL);
?>
require_once("../include/top.php");?>
require_once("../include/bottom.php");?>