getting values into a database from a checkbox

I am trying to a check box in a form to output something like a 0 or 1 or Y and N, just something to tell me if it was checked or not.

<input type="checkbox" name="bridal" placeholder="Bridal" value="yes">

This is what I have as an example and no matter what I have done so for, it just says 'ON' in the SQLlite database.

Can anyone give me a bit of insite as to where I should be looking?

Thanks.