Re: table locking and priorities

2001-06-13 Thread Mohammad Shoja
ame field is text and number so you I can't autoincrement a > username like "abc003434" ... > > > - Original Message - > From: "Mohammad Shoja" <[EMAIL PROTECTED]> > To: "anna soobrattee" <[EMAIL PROTECTED]> > Sent:

Re: table locking and priorities

2001-06-13 Thread anna soobrattee
Hi, The username field is text and number so you I can't autoincrement a username like "abc003434" ... - Original Message - From: "Mohammad Shoja" <[EMAIL PROTECTED]> To: "anna soobrattee" <[EMAIL PROTECTED]> Sent: Wednesday, June 1

table locking and priorities

2001-06-13 Thread anna soobrattee
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 abc2 abc3) which will be used as the username for the next user to sign up... the