online test repeating questions
Posted: Sat Oct 09, 2010 6:54 am
Hi!
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.
its primary key is qid
Please help if anyone can with thanks.
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.