mySQL Table Randomization

[AmishTraveler]

I'm working with a project that is providing a survey to 2,000 people.

There are two parts of the survey with a questionaire and then a form for the participant to enter a drawing for some giveaway items. The two parts are stored in two seperate tables in the database.

The problem is that an advisory board wants the data then randomized each time it is entered so that you can't match the tables up and see that row 5 in the questionaire table has the name and address of row 5 in the drawing table.

Is there an easy way to randomize the data in the database.
I was going to write it so that each time the data from the drawing table is removed into an array then randomized and then reinserted into the table. This seemed very ineffcient to me and when the records would increase as the survey gets more
and more reponses the performance of the script would be in trouble as well.

Does anyone have any other suggestions are more efficient or a better structure for the survey?

Thanks
Patrick

[ereptur]

I don't really know of a way to do this in the database, but if you want to do it on the way back out of the database, such as to another php page, you can always use the "ORDER BY RAND()" statement in the SQL query.

Hope that helps.

[HalfaBee]

How about
INSERT into newtable SELECT * ORDER BY RAND();
rename the original table to a backup name and then rename newtable to the original one.
You should lock the table before doing this.

HalfaBee