What does this query mean

[k994519]

Hi guys

what does this query mean

$query= "select question_id, question from questions q order by question_id";

and how would i and a random function to it ?

thanks for all ur help

[bastien]

get the question_id from the id field

question = the actual question from the question field

list them in order by the question_id field

as for how to randomize it, it depends on what your needs are...the basic way to is to keep a count of how many questions there (call this value q) are and generate a random number between 1 and q.

then select that question based on the ID generated by the above

[k994519]

hi bastien, thank for your help

the randomisation need is that each time the query is run the result are compleltly different form the last time it was run and displayed

could you please write an example query which includes the randomasation part, or if you prefer just writing it in suedo code?

thanks very very very much for your help !!!