hi, i m working on quiz portal in which different set of question were ask
there are 4 mutiple choice question in which one of the right answer.
i successfuly display the question by selecting using perticular test id(topic)
here is the query:*$rs=mysql_query("SELECT DISTINCT FROM mst_question WHERE test_id ='$tid' ORDER BY RAND()",$cn) or die(mysql_error());**
here also i display the question randomly but the problem is each time when i hit next question button the question repeted.
how i can prevent the reptition of question randomly i want to display one question at once with no repetation.
please if anybody have a solution please comment.
Thankyou any help is appreciated.