FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Most efficient way to randomize a quiz from a database
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Most efficient way to randomize a quiz from a database [message #170563] Mon, 08 November 2010 16:08 Go to previous message
Mason Barge is currently offline  Mason Barge
Messages: 5
Registered: November 2010
Karma:
Junior Member
I'm creating a quiz using PHP 5.3 and MySQL (mysqli). The database has
about 1000 questions and answers, in categories, and I want to ask 12
randomly selected questions, one at a time.

Which would be more efficient:

1) Make one call to the database and build an array, stored in session
variables, of 12 randomly chosen rows; or

2) Make 12 requests to the database?

I'm open to other general approaches if anyone has a suggestion I haven't
considered.

I'd like to avoid reloading the page after every answer and I don't see
how I could use Ajax with #1. The quiz has to be in PHP because I need to
generate the final score as a PHP variable, not a javascript variable.
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: how to retrieve xml data from three tables of mysql
Next Topic: Cronjob Apache module v CGI
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 12 21:51:26 GMT 2024

Total time taken to generate the page: 0.03900 seconds