Insert or Update select options into database (PHP/MySQL)
Hi - I have a table that has 6 fields. 4 fields have drop down menus. We want user to be able to select multiple options from within the drop downs. However, only 1 value is being inserted to record initially, and on update, only one option is being updated. We need to have multiple options from within the drop down menu/list added to the field on the database.
Up in the MySQL database, which I administer via PHP My Admin, I had set this field to datatype TEXT. Do I have to change that to ENUM or SET (which is giving me error # 1064?)
How do I resolve this? I am only adding or updating single record at a time. thanks.