php怎么删除数据库指定内容

$sql="select * from kabu where name='$_POST[name]'";

$result=mysql_query($sql,$conn);

mysql_close($conn);

$row=mysql_fetch_array($result);

if($row)
$state="激活成功";

else

$state="激活码无效或者已经使用";

$array=array('state'=>$state);

echo json_encode($array);

这个是判断是否存在,我想判断以后然后删除那条信息,
怎么做?

$sql="select * from kabu where name='$_POST[name]'";
$result=mysql_query($sql,$conn);
if(!empty($result)){
$sql1="delete from kabu where name='$_POST[name]'";
$result1=mysql_query($sql,$conn);
if($result1)
{
echo "删除成功!";
}
else
{
echo "删除失败!!";
}
}