I need to allow a user to select a value from a few available options, and to store his selection in the "users" table. So far so easy. My problem is that I need to allow him also to select "other", and then he enters free text, that also should be stored. How should I design the tables and the querys to enable this?
Thanks a lot!