Algorithm for querying linearly through a non-linear list of questions
- by JoshLeaves
For a multiplayers trivia game, I need to supply my users with a new quizz in a desired subject (Science, Maths, Litt. and such) at the start of every game.
I've generated about 5K quizzes for each subject and filled my database with them. So my 'Quizzes' database looks like this:
|ID |Subject |Question…