Before I ask my question, I just wanted to thank everyone that replied to my question yesterday -> Countdown using javascript.Idea: I created a quiz using php, but I would like to create a MySQL Database and having a table with all the questions, answers and multiple choice stored inside. Issue:Since the quiz is multiple choice, I don't know how to go about storing the multiple choice options in the table. Could I store the options and have each answer separated by a special character and let php get the string and separate the options?Ex: Question: What is your favorite color? Options: Blue=Red=Purple=Yellow.(Database View) What do you folks think is the best practice for something like this?
Storing more then one sting in a MySQL Database Table
- Thread starter marvinmtz
- Start date