Am working on an online examination system. I have ordered the question output with "ORDER BY 1 ASC" and it follows as its appears in the database. But I want the output to be randomly generated so that each time the examinee logs in, different question number comes first.
SAMUEL_8 0 Newbie Poster
rubberman 1,355 Nearly a Posting Virtuoso Featured Poster
Assuming your web server is running with PHP, there is a rand() function that you can use to generate a random number for each entry, and sort it by that. Here is the manual page: http://php.net/manual/en/function.rand.php
jj.dcruz 0 Junior Poster
since you want to create a random questionare you will need all the questions in order from min - max numbers
you will use the rand(min,max); command for this is already given By rubberman
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.