Help : Delete a file and entry on database

[fandhie]

hi.. i need a help with my following php script

<?php  include"../config/kconnection.php"; 

$id="$_GET[id]";
$thumbnail=mysql_query("SELECT * FROM tb_produk WHERE pro_id=$id");
$r=mysql_fetch_array($thumbnail);
$thumb = "../image/$r[pro_thumb]";
unlink($thumb);

mysql_query("DELETE pro_thumb FROM tb_produk WHERE pro_id=$id");
header("location:lihat.php?id=$id");

?>

with those script I want to delete an image file then delete an entry on my database table.
The deleting file is work but not the deleting data. Can sombody help me to show whats wrong with these script?

[dagon]

DELETE FROM tb_produk WHERE pro_id=$id

[bradgrafelman]

Note that dagon's suggestion will remove the entire row. If you're simply trying to remove the data from that row in the database, then you need to UPDATE that row and set the column to an empty value.