xProteuSx Posted December 18, 2007 Share Posted December 18, 2007 I am trying to create a multiple choice test script, where the user can choose the number of questions to be displayed. Now, once that number is input, I would like my script to randomly select that number of rows from a DB that is storing the question data, without duplicates. So, say I have 100 questions/rows in my DB, and I choose to have a 5 question quiz, I would like it to show, for example: row18 row3 row89 row99 row40 Then, next time, I would like it to show, for example: row 72 row 73 row4 row52 row16 I do not ever want it to show, for example, this: row16 row93 row16 row44 row2 Any ideas?? Quote Link to comment Share on other sites More sharing options...
fenway Posted December 18, 2007 Share Posted December 18, 2007 Random how? Quote Link to comment Share on other sites More sharing options...
xProteuSx Posted December 18, 2007 Author Share Posted December 18, 2007 I am trying this for now: $query = 'SELECT * FROM test ORDER BY RAND(NOW()) LIMIT ' . $testsize ; It seems to work, and I am hoping that it will allow me to accomplish what I am trying to do. So for now its onto bigger and better problems ... Quote Link to comment Share on other sites More sharing options...
fenway Posted December 18, 2007 Share Posted December 18, 2007 You don't really need to seed rand() like that... it's fine on it's own. I just meant random over multiple groupings or not. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.