|
Cardea News
query("UPDATE news SET visible='$set' WHERE id='$visib';");
if (!$result) {
echo " Database Error: ".$DB->error()." ";
foot();
die();
}
else {
echo "This news item has been ";
if ($set == "Y")
echo "restored";
else
echo "hidden";
echo ". \n";
}
}
if ($addcom) {
$result = $DB->query("INSERT INTO news (author, newstext, visible, dated) VALUES ('$author', '$text', 'Y', NOW());");
if (!$result) {
echo "Database Error: ".$DB->error()." ";
foot();
die();
}
echo "Your comment has been added. ";
}
}
/* End process form input */
/* Display casualties list */
$query = "SELECT id, author, newstext, dated, visible FROM news ORDER BY dated DESC";
$result = $DB->query($query);
if ($result) {
echo "\n";
/* echo " \n";
echo " | Date | Author | News | ";
if ($admin)
echo "Admin | ";
echo "\n";
echo " \n"; */
$line = 0;
while ($row = $result->fetch_array()) {
if ($admin || $row["visible"] == "Y") {
echo " \n";
echo " | Written by ".$row["author"]." on ".undate($row["dated"])." | \n";
if ($admin) {
echo "";
}
echo " \n";
echo " \n";
echo " | \n";
echo " ";
if ($row["visible"] == "N")
echo "";
echo "".nl2br(htmlentities($row["newstext"]))."";
if ($row["visible"] == "N")
echo "";
echo "
| \n";
echo " \n";
$line = 1 - $line;
}
}
if ($admin) {
echo "
| \n";
echo "\n";
}
echo " \n";
}
else {
echo "DB error: ".$DB->error();
}
?>
Back to the Cardea home page
|
