PDA

View Full Version : picking data at random from database???



- |Flash Man| -
October 17th, 2006, 06:30 PM
i'm wondering if it would be possible to have a query or php script that would grab at random say 20 questions from a pool of 300 that the user has not already seen....as to eliminate cheating

it would be something to do with cookies and storing data of which email address has had which questions already.

any ideas??

cheers in advance peeps :):)

evildrummer
October 18th, 2006, 08:21 AM
well what are you putting the data into?

Regardless I would give each of the 300 questions an id and then create 20 random numbers in flash/php and then grab those from a database, about the stopping same answers you could EITHER have people sign up and store which questions they have seen OR use cookies but they are easy to delete or use sessions in which case they will be deleted at end of dad or less sometimes.