Hi,
I can't seem to locate a mysql select/update query to do the following example.
User 1 submits the form and his SPOT# is 23
User 2 submits the form and his SPOT# is 24
User 3 and a User 4 submits the form at the same time giving both Users SPOT# 25.
How can I do a select/update query which will NOT allow user 3 and user 4 to have the same SPOT#.
Hi, Yes just wanted to add that I already have the primary set to auto_increment so it's not going to allow me to set another column to auto
I can't seem to locate a mysql select/update query to do the following example.
User 1 submits the form and his SPOT# is 23
User 2 submits the form and his SPOT# is 24
User 3 and a User 4 submits the form at the same time giving both Users SPOT# 25.
How can I do a select/update query which will NOT allow user 3 and user 4 to have the same SPOT#.
Hi, Yes just wanted to add that I already have the primary set to auto_increment so it's not going to allow me to set another column to auto