checking usernames in database, so they do not double up

[dv6cougar]

alright, so i have a login for something i'm working on, and I dont' want users to have the same Usernames.

Now i'm thinking of just using a selection query to get my login info from the database, so that is what i naturally did... here's my code

//run selection query to pull usernames from database
$select = "SELECT * FROM users ";
$selectql = mysql_query($select);

//use mysql_fetch_array to grab the data as an array
while($row = mysql_fetch_array($selectql)) {


//set $login2 equal to usernames in database
$login2 = $row["1"];

//close while statement
}

//compare $login to our database username ($login2)
if($login == $login2) {
//if they match, echo error
echo "<tr><td class=\"2nd\">Your username, <b>$login</b> is already in use be another member, please go back</td></tr>";
} else {
//continue with query

now that does work... however it only pulls the last user for comparison, not all of them as I would ahve figured it would 🙁

thanks!

[toma42]

You can move the logic to the database using a unique index:

create unique index idx_userid on users (userid);

However, your code makes it appear you're an amature sql person. Look into the WHERE clause for sql statements to learn more about how to select specific data rather than selecting the whole user table.

[dv6cougar]

Originally posted by toma42
You can move the logic to the database using a unique index:


create unique index idx_userid on users (userid);

However, your code makes it appear you're an amature sql person. Look into the WHERE clause for sql statements to learn more about how to select specific data rather than selecting the whole user table.

not amatuer, not fully trianed 😃

anyway.... well nm! i get your point with the WHERE cluase!!!

WHERE username='$username' 😃

good call!

thanks!! 🙂

EDIT: that was a success, and i'm gonan read up on unique id's now 🙂