sjmiller Posted March 26, 2009 Share Posted March 26, 2009 Is there any way to generate a select form with options deriving off of the values of an ENUM field in MySQL? I'd like to cut out the middle man of having to manually go in and type out the select options so that they match the values of the enum field, and if possible (long shot here) be able to easily edit the values in the ENUM via a form. Is this a little extreme or doable? Quote Link to comment https://forums.phpfreaks.com/topic/151244-form-generated-from-mysql-enum-values/ Share on other sites More sharing options...
Mchl Posted March 26, 2009 Share Posted March 26, 2009 You could try parsing output from SHOW COLUMNS FROM http://dev.mysql.com/doc/refman/5.1/en/show-columns.html If you foresee that the ENUM values will be changing frequently, then you should probably NOT use ENUM datatype, but some kind of lookup table. Quote Link to comment https://forums.phpfreaks.com/topic/151244-form-generated-from-mysql-enum-values/#findComment-794496 Share on other sites More sharing options...
fenway Posted April 1, 2009 Share Posted April 1, 2009 You can use the information_schema tables in mysql 5... Quote Link to comment https://forums.phpfreaks.com/topic/151244-form-generated-from-mysql-enum-values/#findComment-798555 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.