2 things..Checking if user exists..

Anon

Hi people
i have made a sign up form but i need the coding that will, when the submit button is pressed does the following:
1. Checks if the username is allready in use
2. On the form there are 2 password boxes. I need it so the script looks at the two password boxes to made sure they are the same.

Any help would be greatly appreciated

Thanx

Jonathan

Anon

sorry buddy,

q1: you didn't say how you intend to keep track on which usernames are in use - a database? you need to be more specific im afraid.

q2:

if (trim($pass1) == trim($pass2))
{
// ok - same password
}
else
{
// these things differ...
}

amcgrath

Just for the hell of it, vfwood, let's assume he is using a db (anything else would be dumb, imo)... Jon, put a unique index on the user_name column, then you can either check first select count(*) from user where user_name = '$user_name' or insert the user name with an @ sign to suppress the unique key error. If you get it, you'll know.

Anon

Yeah im using a mysql database lol

amcgrath

Well, did our responses answer your quesiton, or not?

Anon

hmmmm, no.... lol

The checking if username allready exists thing does not work. Theres gotta be sum sort of query that can handle this. I know there is but i dont know how to phrase the query.

Thanx anyway guys

Jonathan

amcgrath

Jon, maybe you didn't understand my first post: you can either select count(*) form your user table where the user_name column = the proposed $user-name form the form. If you find one, throw an error. You can also put a unique index on the user_name column, and supress any database errors when you run the query with an @ sign. If you get an error then hadnle accordningly...