wait your turn/insert script

[Greaser9780]

I am tryin to develop a script in which users will make a choice from a list and then it will get inserted as choice 1,2, etc. There is a set order in which these users must go by. (in order of registration id) I'm trying to figure out how to make the script tell if it is a users turn to choose. I am thinking about adding a field in my users table with the type enum value is = to total number of choices. What could I use to set the enum to the next value. I was thinking something like:

Update `users` INCREMENT `order`

Not sure if that is a valid mysql query though.

 

Any thoughts?

[Jessica]

If you make it an int,

UPDATE users SET order = order+1