Greaser9780 Posted February 21, 2007 Share Posted February 21, 2007 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? Quote Link to comment Share on other sites More sharing options...
Jessica Posted February 21, 2007 Share Posted February 21, 2007 If you make it an int, UPDATE users SET order = order+1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.