Users account information and e-mail

[toplisek]

If I have users and registration page has e-mail for users. The same is account page if user would like to change his e-mail address.

In the registration page:
Is correct that user can create new username and the same e-mail address or I should not allow this?

In the account page:
Username is unique in db.
If user would like to change his e-mail, can be his e-mail address as one e-mail that is already in db for another user?

Need help

[dreamcatcher]

Hi toplisek,

Can you not just run a check to see if the e-mail exists? If it does, tell the user to choose again. Also, it might be a good idea to have the user verify their address before it becomes active.

dc

[coopster]

You could add a UNIQUE keyword to the email address column of the table too. It all depends on whether or not you want the user to be able to have multiple userIDs with the same email address.