Looks like more of a php question that a mysql question ;)
anyway, the mysql part:
use either an unsigned interger (tinyint, if less than 256
possibilities, smallint if over 256 but less than 65565, etc)
or use a set or enum.
Using a varchar is not really the way to go.
If you choose to use an integer and you need some kind of string
representation of the choice, use a secondary table to hold the string
values and let the integer in the main table be a foreign key to the
secondary table ;)
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?
I hope I am asking this question correctly. If not, please feel free to flame
me.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
