Online Quiz System - Questions random order help

[mahendrakalkura]

hi guys

i have a great problem on my hands here

i am developing a online quiz system for my college

i put the questions in a database

i call them ordered by id using a select statement

ie : "select * from questions order by id"

and after they have pressed submit i evaluate the answers as follows

/**********************************************************

$list_questions = "select * from questions order by id";
$display = mysql_query($list_questions,$connectparam);
$score = 0;
$total = mysql_num_rows($display);
while ($result = mysql_fetch_array($display)) {
$answer = $result["answer"];
$q = $result["q"];
$star = $result["star"];
if ($$q == $answer) {
$score++;
if ($star==1) {
$score=$score+5;
}

}
if ($star==1) {
        $total=$total+5;
    }

**********************************************************/

this works fine

the database is as follows

id | q | question | option1 | option2 | option3 | option4 | answer | star

but my sir told today that since 20 ppl will take part simultaneuosly each time the quiz is help he want all of them to get the questions in random order , not the same order each time

so i thought i could use the rand function

but its ok when i display the question

but when i want to evaluate i must call select for all questions again and this time the questions order is different agains

so i cant evaluate the answers

so any of you guys have a solution to my problem

please help me

thanks

[boogiemacs]

Try designing a class, say, TestQuestion, with instance variables, $id, $q, ..., $star. Your constructor should assign a value to each instance variable from the arguments passed. Also, define an instance function, say, isCorrect($choice), that returns true if $choice == $this->answer, or false otherwise.

In your php script, declare an array, say $questions = array().
You'll be using $questions to store an array of TestQuestion objects, instead of an array of question strings.

After your mysql query, and within your while loop, create an instance of each TestQuestion and pass all the query results by row to your TestQuestion instantiation statement:

$question[$i] = new TestQuestion($result["id"], $result["q"], ..., $result["star"])

Then you can run your script that randomly generates the question sets. To check your examinee's answer, just invoke the isCorrect method like this:

if($question[$x]->isCorrect($choice)) // where $choice can be a http post variable. You won't have to query your database again since the object already holds the correct answer.

Good luck!

[mahendrakalkura]

i will get back to you soon ok

[mahendrakalkura]

hi there

did u get my mail

if not tell me

i will mail it again

gimme ur email id

urgent please

thanks anyway

cya soon

[nik_crash]

Sir/Ma'am,
I have the same problem regarding the online quiz?Can you send me your code for my reference?

thank you..

[mahendrakalkura]

hi nik_crash

i am a boy

dont call me madam , lol

anyway mail me at [e-mail] or send me ur email address

i will send u the source ok

cya soon

bye bye

[jayant]

You have:
$list_questions = "select * from questions order by id";

instead of this use:
$list_questions = "select * from questions order by rand() LIMIT 20";

limit 20 will ensure you select only 20 questions, instead of all.

[mahendrakalkura]

thanks anyway jayanth

i already got the answer

thanks anyway

[mahendrakalkura]

one more interesting dought left for me here

can i use php-gtk for this project

i want to use a window like app instead of internet explorer

ie; one server connected to 20 comps

each comp must use the mysql db on the server using php-gtk window interface

can i use it

if so tell me how ok

cya soon guys

bye bye