我试图通过从下拉菜单中选择新闻事件从数据库中删除新闻事件。当用户选择新闻标题并按下提交按钮时,应从相关表中删除新闻项目。无论我尝试什么,我都无法正确地工作。抱歉,我是PHP新手。
有人可以帮忙吗?这里是下拉菜单:
$sql="SELECT newstitle FROM $tbl_name";
$result=mysql_query($sql);
?>
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
?>
}
?>
$delete=$_POST['delete'];
$delete = mysql_real_escape_string($delete);
mysql_query ("DELETE FROM $tbl_name WHERE newstitle='$delete'") or die ("Error- news has not been deleted");
echo "News has been deleted";
header("Location: newsdeleted.php");