I have an Access-to-Mysql translator, which works very well, except I'm stuck on one thing. I think the problem with my query not working is that I'm feeding checkbox data into the field, tinyint(3), which is the field type the translator created from an Access database checkbox.
I ended up doing this: my html side code changed to:
<input type="checkbox" value="Age" name="Age">Age<br>
Of course, this inputs the text Age into the field. At first I changed field type in the database to text and made it big enough to take the text, Age. That works okay. But I'm not sure what the value= should be for my Mysql database that has the tinyint(3) field. I thought that it would take a "1" or a "0" for on and off, something like that, but I don't know and I'm hoping someone might have run across the problem and can help me.
So, to get data from my html checkbox into the Mysql database that has a tinyint(3) field, I would change or do what?
Al