duplicate data...

pythas

I am writing a quiz in php in which questions are taken from mysql database randomly and only 10 questions been displayed from like 100 questions.

I got it all working perfectly, but the problem now is that at times I get the same questions been asked twice in one session.

Can anyone help in stopping this duplicate questions selections please?

ucbones

mysql_query("SELECT * FROM questiontable ORDER BY RAND()");

Should work just fine...

HTH

ucbones

pythas

Thanks but I had already tried that. It didn't work, I got an error. I used...

SELECT * FROM quest_tbl ORDER by RAND(NOW())

Becos the questions are selected at random, there is the posibility of repeatition of questions. This is what I want to avoid/stop.

ucbones

what was the error message?

ucbones

pythas

I tried that and still getting duplicate data.....guess it's got to do with the php code cos i tried it with sql query but never got any duplicate result. Just the result ordered randomly.