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?? Link to comment https://forums.phpfreaks.com/topic/82122-solved-echo-x-number-of-random-rows/ Share on other sites More sharing options...
fenway Posted December 18, 2007 Share Posted December 18, 2007 Random how? Link to comment https://forums.phpfreaks.com/topic/82122-solved-echo-x-number-of-random-rows/#findComment-417341 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 ... Link to comment https://forums.phpfreaks.com/topic/82122-solved-echo-x-number-of-random-rows/#findComment-417423 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. Link to comment https://forums.phpfreaks.com/topic/82122-solved-echo-x-number-of-random-rows/#findComment-417795 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.