I'm doing some sort of a quiz-like chatting system, where a lecturer gives a question and a student answers. For the picture above, lahpis would be the lecturer and 0700211Q would be the student answering the question. All these are in plain text.
I have a table called quizanswers which has the answers for the quiz in the database. It has (quizid,questionid,answer).
I was wondering if it's possible to compare value the answer a student types to the correct answer in the database.
I hope I phrased my question correctly. If there's more information I need to add, please let me know and I see if i'm able to include anymore details.