[SOLVED] delete one field "img0" from index number "rid"

[sungpeng]

$delete=mysql_query("DELETE FROM listings.img0 WHERE rid = '$rid'");

 

hi check how to delete one field "img0" from index number "rid".

Above code not working

 

Thank

 

[Mark Baker]

You don't delete fields/columns in SQL, you can only delete rows.

 

You can, however, set fields to a null value

$update=mysql_query("UPDATE listings SET img0 = NULL WHERE rid = '$rid'");