Edit Article
require("news.php");
$link = jn_init();
if($HTTP_POST_VARS) {
//
// Article submitted
//
$query = "update news set ".
"topic = \"". $HTTP_POST_VARS["topic"] . "\",".
"text = \"". $HTTP_POST_VARS["text"] . "\",".
"picurl = \"". $HTTP_POST_VARS["picurl"] . "\",".
"pictext = \"". $HTTP_POST_VARS["pictext"] . "\",".
"datemodify = ". time() . " ".
"where art_id = " . $HTTP_POST_VARS["id"];
$result = mysql_query($query, $link);
//mysql_free_result($result); // Error !!??
echo
"
".
"Success ".
"back";
}
elseif($HTTP_GET_VARS) {
//
// article edit form
//
$query = "select * from news where art_id = " . $HTTP_GET_VARS["id"];
$result = mysql_query($query, $link);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
echo
"\n";
mysql_free_result($result);
}
else {
//
// Article list
//
$query = "select * from news";
$result = mysql_query($query, $link);
echo ("
\n");
echo ("new article
\n");
echo ("
\n");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo("+ \n".
" " . $row["topic"] . "
\n");
}
mysql_free_result($result);
echo ("
\n");
}
mysql_close($link);
?>