07-20-2009, 07:19 AM
|
#5 (permalink)
|
|
The Acquainted
Join Date: May 2009
Location: Durham, UK
Posts: 134
Thanks: 9
|
Quote:
Originally Posted by skp
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.
|
|
|