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 https://forums.phpfreaks.com/topic/243324-storing-checkbox-answers-from-an-html-form-into-mysql/ 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 https://forums.phpfreaks.com/topic/243324-storing-checkbox-answers-from-an-html-form-into-mysql/#findComment-1249575 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 https://forums.phpfreaks.com/topic/243324-storing-checkbox-answers-from-an-html-form-into-mysql/#findComment-1249578 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 https://forums.phpfreaks.com/topic/243324-storing-checkbox-answers-from-an-html-form-into-mysql/#findComment-1249581 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 https://forums.phpfreaks.com/topic/243324-storing-checkbox-answers-from-an-html-form-into-mysql/#findComment-1249783 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.