Check user against database

[SaraLynn]

Hi,Can someone tell me how to make my register form check my MySQL database when someone signs upon my site to see if the username is available?. Currenly it has no error checking so the same usename can be registed over and over again.thanks so much,Sara Lynn

[aspnetguy]

before you insert the user into the database do a select statement to get a list of all the users in the user table. Then use a for loop to see if the provided username already exists in the return results array.

[reportingsjr]

or, you can do a select query to search the username from the database, get the result and use mysql_num_rows to see if that user name, is either 1, it exists, or 0, its open. That might be alot easier!

[aspnetguy]

or, you can do a select query to search the username from the database, get the result and use mysql_num_rows to see if that user name, is either 1, it exists, or 0, its open. That might be alot easier!

Yeah that would be more efficient too.

[SaraLynn]

Thank you,With your input and php.net I got it..