Nicholas Vettese wrote:
> I am trying to allow a user to use checkboxes for multiple selections, and I am
> trying to get the database to record the choices made by the user. I am using a
> VARCHAR(250), but I am guessing that may be wrong. Also, other than adding a "" to the
> end of the 'name' (e.g. <input type="checkbox" name="mod_type" value="alternative"
> />Alternative<br />), what do I need to do?
If you have N = a large number of checkboxes, if the list will
definitely not change, and if they are not likely to require frequent
individual edits, saving them as a string of N 0|1|? values can be quite
efficient for saving retrieving them. We've written test scoring
software based on that. But if frequent item edits are possible, you are
further ahead saving each as a named TINYINT.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.4/399 - Release Date: 7/25/2006