I have create a field in MySQL like this:
<pre>
+---------------+---------------------------------+------+-----+---------+-------+---------------------------------+
| Field | Type | Null | Key | Default | Extra | Privileges |
+---------------+---------------------------------+------+-----+---------+-------+---------------------------------+
| contact_pref | enum('email','telephone','fax') | | | email | | select,insert,update,references |
</pre>
I can only get enum from mysql_field_flags(), I would like to get the information
in enum: email, telephone and fax; as well as the default value. How can I do this?
<pre>
+---------------+---------------------------------+------+-----+---------+-------+---------------------------------+
| Field | Type | Null | Key | Default | Extra | Privileges |
+---------------+---------------------------------+------+-----+---------+-------+---------------------------------+
| contact_pref | enum('email','telephone','fax') | | | email | | select,insert,update,references |
</pre>
I can only get enum from mysql_field_flags(), I would like to get the information
in enum: email, telephone and fax; as well as the default value. How can I do this?