[SOLVED] Simple PHP MYSQL problem

[fri3ndly]

I am trying to make a 'delete image' button that will remove the thumbnail and image ONLy from a table containing property information and images. How do i delete only from 2 columns of the table?

 

Is this right? Only it deleted the whole property!

 

$remove_image_query = mysql_query("DELETE FROM properties WHERE property_id='$prop_id' AND photo_thumb='$photo_thumb' AND photo_standard='$photo_standard'")or die(mysql_error());

[haku]

That will delete the whole row from the table.

 

If you want to delete a couple fields from a table, just set those columns to null using UPDATE.

[fri3ndly]

Lol, I didnt even think of that.

 

Thanks a lot

[fri3ndly]

So is this right? Not changing the fields to a blank but just leaving them as they are:

 

$remove_image_query = mysql_query("UPDATE properties SET photo_thumb='', photo_standard='' WHERE property_id='$prop_id'")or die(mysql_error()); 

	if ($remove_image_query){
	echo "Image deleted and removed from database.";
	}

[haku]

That will work, but I prefer NULL myself.

(ex SET photo_thumb='NULL')