Remove record from MySQL

[doby48]

I have a table in my DB for newsletter subscribers. Currently, when they unsubscribe I just set the customers_newsletter field from 0 to 1. I would instead like to remove the customers record if they unsubscribe. Can someone guide me in the right direction as to how I can add something like this to my code?

Thanks in advance.

[Elizabeth]

mysql_query("DELETE FROM [i]tablename[/i] WHERE customers_newsletters='1'");

hth!
-Elizabeth