function enum_select( $table , $field ){
        $query = " SHOW COLUMNS FROM `$table` LIKE '$field' ";
        $result = mysql_query( $query ) or die( 'error getting enum field ' . mysql_error() );
        $row = mysql_fetch_array( $result , MYSQL_NUM );
        $regex = "/'(.*?)'/";
        //$regex = "/'[^"\\\r\n]*(\\.[^"\\\r\n]*)*'/";
        preg_match_all( $regex , $row[1], $enum_array );
        $enum_fields = $enum_array[1];
        //print_r($enum_fields);
        return($enum_fields);
}

If you just want to see the values uncomment the print_r line and execute the function:

enum_select(table1,field1);

Now for example if you want to create a dropdown with this array you do:

echo "";
$enum_array = enum_select(table1,field1);
foreach ( $enum_array as $field ) { 
echo "".$field."";
}   
echo "";

The result will look something like this:

Tags: enum field, html, mysql, php