I'm trying to add multiple values from a drop down list to a field in mysql.
The originating data is from another table of the same database.
I'd like to be able to (by "ctrl + click") select more that one of these from the list and add them to a single field within a file. I've got a few books and have done some online research on this but to no avail, is this possible in MySQL????
Edit: BTW. I'm using Dreamweaver MX 2004 as a web editor if that helps, and I've been able to make multiple selections with a tool option in the application, but only the first of the selected options is what's added in the MySQL field.

Thanks,
Ray

adding multiple values to a field is not a good idea

adding multiple rows, with one value per field, that's fine

so what's the best way to go about this?

add multiple rows, one for every value in the dropdown list