Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HELP!! Enum field in mysql
- Thread starter rbauerle
- Start date
sleipnir214
Programmer
I don't know about a specific function, but here's one way to do it:
Given the following table:
[tt]+---------+--------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------------------+------+-----+---------+-------+
| id | int(10) unsigned | | PRI | 0 | |
| enumval | enum('Yes','No','Maybe') | | | No | |
+---------+--------------------------+------+-----+---------+-------+
[/tt]
The following code will get you the list of enum values for the column enumval in an array:
[tt]
[/tt]
Given the following table:
[tt]+---------+--------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------------------+------+-----+---------+-------+
| id | int(10) unsigned | | PRI | 0 | |
| enumval | enum('Yes','No','Maybe') | | | No | |
+---------+--------------------------+------+-----+---------+-------+
[/tt]
The following code will get you the list of enum values for the column enumval in an array:
[tt]
Code:
<?php
$link = mysql_connect ("localhost", "test", "test");
mysql_select_db ("test", $link);
$query = "show columns from foo like 'enumval'";
$result = mysql_query ($query, $link);
$vals = mysql_fetch_object ($result);
$enums = preg_split ("/,/", preg_replace ("/enum|\)|\(/", "", $vals->Type));
print_r ($enums);
?>- Status