skidmark10 Posted July 30, 2011 Share Posted July 30, 2011 Hello, I am trying to store checkbox answers into a table in mysql. What should the table input be? I'm using enumeration, but my answers aren't appearing. What am I doing wrong? Quote Link to comment Share on other sites More sharing options...
popcop Posted July 30, 2011 Share Posted July 30, 2011 what do you currently have it set as in the database? Quote Link to comment Share on other sites More sharing options...
skidmark10 Posted July 30, 2011 Author Share Posted July 30, 2011 what do you currently have it set as in the database? CHANGE `Slim_Slender` `Slim_Slender` ENUM( 'Slim|Slender' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , CHANGE `Average` `Average` ENUM( 'Average' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , CHANGE `Athletic` `Athletic` ENUM( 'Athletic' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , CHANGE `Heavy` `Heavy` ENUM( 'Heavy' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL Quote Link to comment Share on other sites More sharing options...
popcop Posted July 30, 2011 Share Posted July 30, 2011 would you not just have then set as TEXT ? Quote Link to comment Share on other sites More sharing options...
fenway Posted July 31, 2011 Share Posted July 31, 2011 You're not supposed to store values from checkboxes that way -- not to mention that's not the correct ENUM syntax. Store answers generically. Quote Link to comment 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.