Using an HTML checkbox to put 1 or 0 into a MySQL table

[GlennW]

I am using a simple HTML checkbox in a form to put a 1 for checked and a 0 for unchecked in a field called "subcheck" in a MySQL table.Does the checkbox default to 1 for "checked" and 0 for unchecked? If not, how can I give it those values?Thanks in advance,JohnForm:\[code\]<div class="subcheck"><INPUT TYPE=CHECKBOX NAME="subcheck">Click here to receive free money in the mail.<P></div>\[/code\]In the file the form goes to:\[code\]$subcheck = $_POST['subcheck'];mysql_query("INSERT INTO submission VALUES (NULL, '$uid', '$title', '$slug', '$cleanurl', '$displayurl', NULL, '$subcheck')");\[/code\]The MySQL table:\[code\]`submission` ( `submissionid` int(11) unsigned NOT NULL auto_increment, `loginid` int(11) NOT NULL, `title` varchar(1000) NOT NULL, `slug` varchar(1000) NOT NULL, `url` varchar(1000) NOT NULL, `displayurl` varchar(1000) NOT NULL, `datesubmitted` timestamp NOT NULL default CURRENT_TIMESTAMP, `subcheck` tinyint(1) NOT NULL, PRIMARY KEY (`submissionid`))\[/code\]