嗨,我正在尝试从数据库中删除某些列数据。这是我用于删除查询的代码。
//getting column id by comparing the id need to delete the data from that row.
$id=$_GET['id'];
$res = "DELETE rental_annual_rent,
rental_block,
rental_street,
rental_area,
rental_town,
rental_state,
rental_pincode
FROM house_details
WHERE house_details_id='$id'";
$result=mysql_query($res);
if(mysql_affected_rows()){
echo "successfully deleted";
session_start();
header("Location:property.php");
}else{
echo "Failure";
}
首先,我将house_details数据插入数据库,但我只需要从该列中删除特定数据
你想要的是一个UPDATE
,而不是一个DELETE
,因为你想保留行,而只是清除/空白/取消设置行中的某些列。
$res = "UPDATE house_details SET
rental_annual_rent = NULL,
rental_block = NULL,
rental_street = NULL,
rental_area = NULL,
rental_town = NULL,
rental_state = NULL,
rental_pincode = NULL
WHERE house_details_id='$id'";
请注意,在查询中使用id
输入之前,您应该对其进行清理,您应该对其进行参数化,并且还应该从mysql
库迁移到mysqli
或PDO