PHP: Checking User

Posted: Wed Mar 12, 2003 6:41 pm (21 years, 1 month ago)

I have a mySQl table with a list of usernames and passwords in it. When a user registers I want it to check if a user of that name is allready in the database. How would I do this?

Regards,

Posted: Wed Mar 12, 2003 6:49 pm (21 years, 1 month ago)

first select data from the database where the username = whatever the user requested as their username. Then use mysql_fetch_row() or mysql_fetch_array() to see if the result == NULL. if it does, then continue and create the account. if not, give the user an error.

Team Member Joined: 06 Jan 2002 Posts: 2564

Or you could do what adam suggested and then use mysql_num_rows to see if there is more than 0 rows...

Posted: Wed Mar 12, 2003 7:02 pm (21 years, 1 month ago)

thinking about it, I like daniel's idea better Very Happy

using mysql_num_rows() would look neater.

Posted: Wed Mar 12, 2003 7:07 pm (21 years, 1 month ago)

Thanks