<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>View Zodiac Feedback</title>
</head>
<h1>Zodiac Feedback</h1>
<?php
//if (empty($_POST['name']) || empty($_POST['comments']))
// echo "<p>You must enter your name and comments! Click your browser's Back button to
// return to the Zodiac Feedback form.</p>";
//else {
// $Date = date("Y-m-d H:i:s");
// $DateOnly = strtok($Date, " ");
// $Time = strtok(" ");
include ("includes/inc_connect.php");
if (!$db === FALSE) {
$TableName="zodiacfeedback";
$Name = stripslashes($_POST['name']);
$Comments = stripslashes($_POST['comments']);
if (stripslashes($_POST['pubdisplay']) == TRUE)
$Pubdisplay = "Y";
else
$Pubdisplay = "N";
$SQLstring = "SELECT * FROM $TableName WHERE public_message='Y'";
$QueryResult=@mysql_query($SQLstring, $DBConnect);
if ($QueryResult === FALSE)
echo "<p>Unable to execute the query.</p>" . "<p>Error code " . mysql_errno($DBConnect) . ": " . mysql_error($DBConnect) . "</p>";
else {
echo "<table width='100%' border='1'>\n";
echo "<tr><th>Date</th><th>Time</th><th>Sender</th><th>Comments</th></tr>\n";
while (($Row = mysql_fetch_row($QueryResult)) != FALSE) {
echo "<tr><td>{$Row[0]}</td>";
echo "<td>{$Row[1]}</td>";
echo "<td>{$Row[2]}</td>";
echo "<td>{$Row[3]}</td></tr>\n";
}
echo "</table><br /><br />";
}
mysql_close($DBConnect);
}
//}
?>
<body>
</body>
</html>