如何从mysql数据库中删除一列，当它显示在一个jquery对话框与ajax的while循环 - how to delete a column from a mysql db when its displayed from a while loop in a jquery dialog with ajax

how to delete a column from a mysql db when its displayed from a while loop in a jquery dialog with ajax

我有这段代码显示在jquery对话框中。load()'从php脚本中读取

$sql = '
    SELECT
        *
    FROM
        table
    WHERE
        id="'.$id.'"
';
$query = mysql_query($sql);
while($rows = mysql_fetch_array($query)) {
    echo "Category: <input type='text' name='category[]' value=".$rows['category']." />";
}

这是一个表单的一部分，它被发布到一个外部脚本来插入/更新数据库。问题是我如何删除该列onclick通过添加一个href"删除"输入后回显，有效地从数据库中删除它?

while($rows = mysql_fetch_array($query)) {
    echo "Category: <input type='text' name='category[]' value=".$rows['category']." />";
    echo "<a href="UrlWhereCodeOfDleteToBEWrite?task=delete&cat=".$rows['category'].">Delete</a>";
}

在文件中上述链接将重定向写入

if(isset($_GET['task']) && $_GET['task'] == 'delete'){
   if(!isset($_GET['cat'])){
      die('Invalid cat to delete');
   }  
   $sql = "DELETE FROM tableName WHERE columnName = '".$_GET['cat']."' ";
   mysql_query($sql); 
}