Random data from mysql

[manjuhugar24]

HI everyone,
I want to fetch random questions from mysql in to my web page for this i have used RAND() function but the poblem is everytime i refresh my webpage data is randomizing but i want random data only once and it should not randomize again on page refresh.Can anyone help me please ?

[Mohammed Zayan]

the total rows should be big than your limit
if you view 10 rows in the page you must have more than 10 in your database

[NogDog]

Store the results of the query in session data, and then only actually run the query (and populate that session data) if the session data is empty.

[manjuhugar24]

Thank you so much NogDog it really worked for me as you said i stored my query in session variable and it executes only if that session is not set.
Thanks once again