10 random quiz questions from a bank of 15

[Kisan]

I have a table for a quiz program

quiz(
  quizid,
  quizlevel,
  questionid,
  question,
  answer,
  PRIMARY KEY (quizid),
  KEY quizquestion (quizid,questionid)
);

quizchoices(
  choiceid,
  quizid,
  questionid,
  choice
);

"SELECT
    quiz.quizid, quiz.questionid, question, choiceid, choice, answer, quizlevel FROM 
    quiz 
INNER JOIN 
    quizchoices 
ON 
    quiz.quizid = quizchoices.quizid 
ORDER BY 
    quiz.quizid, quiz.questionid, choiceid"

I get 15 questions with four options for each question.

Now I need to randomize 10 questions with four options for each question from a bank of 15 question.

I am totally clueless...

[Mittineague]

You could put the db results into an array. shuffle() the array, and use the first 10.

[kromey]

You can do this in your database query:

ORDER BY RAND()
LIMIT 10

You may need to put the RAND() in your SELECT column list (something like SELECT ...., RAND() AS random) and then ORDER BY that column (ORDER BY random).