I have a table which stores all the answers of a questionnaire. One
of the field name is question_number. This field has values from 1 to
11. the other fields in the table are user_id and answers to the
question.
Whenever a question is answered, the question_number,user_id and answers are stored in the table.
My
application has a menu list with "question1","question2" upto "Question
11" as the contents of this menu. on the home page load, I need to
check the questions previously answered by the particular user and
depending on the result, I need to change the menu "style". Ex: if
question 3 and 7 are already answered, I need the menu button for
"Question 3" and "Question 7" to be in red color as opposed to the
default green color for the other Question numbers.
I'm
trying to figure out the best way to accomplish this. If I had to
select and return just 1 value, it would be easy to do ...
Go to the complete details ...