Posted by google on 10/07/05 17:53

Is it possible to fill a field with multiple values ? I am cataloguing
products that can fall into multiple subcategories (all of which are
referenced by an id key to another table containing the subcat titles,
i.e. 0=vintage, 1=mens, 2=womens etc.)

What I really want is an enum type field that I can fill with more than
one value. I would use seperate fields (subcat1, subcat2 etc.) but the
field, presently called id_subcategory is special in that when my
script encounters 'id_' it uses the following characters
('subcategory') as the name of the table containing the values for the
html select form. Therefore I would need to have several separate but
identical tables to pull the subcategories from. Not impossible, but
annoying the have to update five tables each time a new category is
added.

Any experienced MySQL'ers have a solution to my problem ? Thank you

[Back to original message]