Random content from MySql DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I`m creating a small application that let users take test online, the
user will login and visit the test page, questions and answers are
stored in MySql database,

i want to display each randomly without repeating.

test must to completed between some specific amount of time or else
the application will forcefully submit the form and calculated the
completed ones (Eac question come up at a time and you choose the
answer and submit, then another come show up again, just like that),

I have plan of saving user`s progress and user may continue next time
if he/she has not spent the total test time.

I need your help on how to random the questions without repeating any
and if a user may need to continue from he/her past, the random should
also exclude the past questions stored inside the user progress table.

What is your best advice, i want to start creating the mysql table soon.

Thank you

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux