Unique login name

[zzz]

I'm trying to write a login script and in it I need to be able to determin whether a new login name is already taken.

Is there some sort of predefined function that would allow me to do that? Alternatively I'd just have to query the db for the same exact login name and if found, I guess return an error.

[devinemke]

zzz wrote:

Alternatively I'd just have to query the db for the same exact login name and if found, I guess return an error.

that is precisely what you must do

[zzz]

ah-ha, finally I'm starting to think like a developer...

[crazychris]

make the login name field a unique key, then an insert will fail if a duplicate is attempted. Check for the fail and you're done.

or

query the table for the login name first, then insert if 0 results.