Hi All,
Can anyone help me...
My registration form looks up the last username in the members table (select
distinct username from members order by uid desc limit 1), and increments
this username (e.g. from abc00002 abc00003) which will be used as the
username for the next user to sign up...
the problem occurs when in the time it takes to do an insert, several
selects can take place - so i have the case where there are users with the
same username (which is not very good at all)
Can I force the selects to lock, whilst the insert is taking place? Has
anyone got any ideas on how to get aorund this ?
Please write back soon!
Anna
