StackApps checkbox/radio button


I am having quite the problem with this little issue. I have a field in a table called flag. It is either a 0 or a 1. I want to use it to display or not display records ( like a delete). I am using the Check/Radio input. I can easily change the field in the database to a 1 by checking the box, but I am unable to change it back to 0 by unchecking. I always get:

Field ‘Void Transaction?’ can not be empty!

I am using a static join to map the fields. Is there a problem writing 0 back to the database (mySQL)?


What about having 2 radio’s. One with value 0 one with value 1?


I did try this and a number of other things. I even just and pasted from the tutorial with no joy.

I wondered if it had something to do with the 0. I don’t know enough about php and mysql to know.