MySQL and Perl with multiple values

[fergmj]

I have a MySQL table that has a column called colors
'colors' is a SET defined as 'blue', 'red', 'yellow, 'green'

On an HTML page, I have a scrolling_list (using CGI.pm) that is populated from the SET of colors.

I want the user to be able to select (for example) two colors 'blue' and 'yellow' and then hit a submit button and I need to store the two values in a record.

How can I do this? All of my other data is just one item and that is very easy to store but I am lost on this one.

Thanks

 

[805pr]

This link may help you...near the midlle they talk of "multiple selects" and writing the choices to an array. Their is some sample cgi code. You just need to add the code to write to the MySql table.

http://www.cgi101.com/class/ch5/text.html