rlelek Posted August 6, 2008 Share Posted August 6, 2008 A quick question on MySQL... If we were to make a datatype in MySQL to store values like a checklist, what should we use? The main goal here is to store varying numbers of data according to a preset table of possible data. If you are familiar with some HTML forms, it may be described better as a checklist where multiple options can be selected, not radio buttons or pull-down inputs where only one value can be selected. The reason for this is the ESRB. We would like to incorporate the descriptors, about 30 different things why games are rated what they are (E-M essentially). Here's a link: http://en.wikipedia.org/wiki/Entertainment_Software_Rating_Board I looked and All I found was SET and ENUM but I really am not sure if these are the right tools for the job Thanks! Link to comment https://forums.phpfreaks.com/topic/118357-mysql-value-from-set/ Share on other sites More sharing options...
fenway Posted August 6, 2008 Share Posted August 6, 2008 If the list of values is fixed, then SET would be fine... otherwise, use a separate table. Link to comment https://forums.phpfreaks.com/topic/118357-mysql-value-from-set/#findComment-609578 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.