I have make an online examination application.
I have a hundreds of questions for one test. when i allocate test for the students then online test paper select 30 question one by one with ORDER BY Rand() after each 30 seconds.
Problem is that there are repeating some questions numbers of time.
How can i solve this problem my query is follow.
Code: Select all
$sqlQuery="select * from question where qstatus = 'Active' AND testid =".$_SESSION['tid']." ORDER BY Rand() LIMIT $offset , $limit";Please help if anyone can with thanks.