I've just started to write a LCMS where administrators can create and publish tests / quizzes for students.
The first stumbling block I've come up against is how I'm going to display the possible answers in a random order.
Here is how things are stored in the DB (MySQL):
What I want to be able to do is echo out the Question text at the top of the page, but then randomise the possible answers so that the correct answer is not always at the top.
I figured that hard coding place holders for the correct answer and alt answers is obviously the wrong way to go because then they'll always appear in their designated place.
Can anyone offer some possible solutions to my problem.
Any help would be greatly appreciated