A doubt on PHP Online Quiz
View Single Post
07-20-2009, 07:19 AM
Join Date: May 2009
Location: Durham, UK
Originally Posted by
Thansk for ur reply. but i want to mak my question clear. Whether can i avoid database retrieval each time for each question for each user , wich wud mak the appln more loaded one & slow . ( for ref- in ASP.net, VB.net, as they are appln oriented, its enuf if DB Query fetch is made only once & can be displayed one at a time by moving the ADO like recordset pointer) So , is it possible to do something lik tht in php..? I wanted to reduce laod on DB engine(MySql).
That's possible too. Retrieve all the questions/answers you want you want and display the row (as in recordset).
Pseudo would be something like:
Get all questions/answers from db
Set a counter i.e. i = 0
Show the first row using counter
When submitted increase counter, so the next row (question/answer) is shown.
View Public Profile
Send a private message to Hightower
Visit Hightower's homepage!
Find More Posts by Hightower