Check user

[ripkk2tfk]

Hi,
Could one of you guys help me fix my code to check if username exsists,
here is what i got

//does username exist?
$check_user="select username from". $db ."where username=".$username;
if($check_user===$username)
{
Echo "already taken!";
}
Else
{
echo "done!";
}

[subzero]

//does username exist?
$check = mysql_fetch_array(mysql_query("SELECT username FROM ". $db ." WHERE username='$username' "));
if($check[0]=="$username")
{
Echo "already taken!";
}
Else
{
echo "done!";
}

[ripkk2tfk]

You the man Sub ;)

[subzero]

i forgot edit one pice userid to username or copy that code again.

Let me know how it workin for you.

[subzero]

i like doing it this way thou!

if(mysql_num_rows(mysql_query("SELECT username FROM $db WHERE username = '$username'")))
{
$msg=$msg."Userid already exists. Please try another one<br/>";
$status= "NOTOK";
}
// if all validations are fail.
if($status<>"OK")
{ 
echo "$msg";
// if all validations are passed.
}else{ 
echo "That Username is free!";
}

[ripkk2tfk]

Ok yea i changed the userid you pasted before to my defined variable ;) but ok whats the difference between the the methods posted?

[subzero]

the one i coded you can add more stuff like email and other stuff like this

if (!stristr($email,"@") OR !stristr($email,".")){
$msg="Your email address is not correct<br/>"; 
$status= "NOTOK";}

if(mysql_num_rows(mysql_query("SELECT email FROM members WHERE email = '$email'"))){
$msg=$msg."Email already exists.<br/>";
$status= "NOTOK";}

You can see the status notok

this will fail the sign up or login.

[ripkk2tfk]

Ok nice i must still learn all this stuff

[Ponick]

I have a m0top script . Its working fine. But i dont see any cetagory . How to create cetagory??

[ripkk2tfk]

Change your permissions