sets in mySQL-- how to read

[sfullman]

Hi, I use phpMyAdmin and have never taken advantage of setting a field attribute to "SET" such as:

If field type is "enum" or "set", please enter the values using this format: 'Mondy','Tuesday','Wednesday'...

My questions are as follows:

1. How can I add a value to a field's set in a database?

2. How can I read the values of a field set (so that I can populate a dropdown list)?

Thank you!!!
Sam Fullman
Compass Point Media

[[deleted]]

Well, it's all in the manual, under the section 'SET'.

But it's better to just forget all about the SET type, and use a seperate table with a PK/FK relationship.

[Rex__]

The only thing worse than terse information is misinformation. You have generously provided both.

After checking the mysql manual, I haven't found any information on drawing enum field sets for populating a dropdown list using php. I have tried the following pages, among others:

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#ENUM

http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#constraint_enum

Could anybody answer these questions? I, too, would like to know how to get enum options from the field properties.