What's wrong? ahh.

[Calon]

Silence is the cleaning function..

Any other method's of checking if a username already exists, in different casing, mine isn't working.




$username = silence($_POST['username']);

$query = mysql_query( "SELECT `username` FROM `userstorage` WHERE username = '$username'" );
$checkname = mysql_num_rows($query);
if($checkname < 0){

echo 'This username is currently in use!';
exit();

}
else {
echo "Woops";
}

[Excellent]

Change the 0 to a 1..? :P

[Calon]

Change the 0 to a 1..? :PStill no. :(

[redtom]

Will this work?


$username = silence($_POST["username"]);

$result = mysql_query("select username from userstorage where username='$username'");
$count = mysql_num_rows($result);
if ($count == 1) {

echo ("This username is currently in use!");

exit();

}

else {

echo("What ever happends if the username is free...");

}

[Excellent]

$username = silence($_POST['username']);
$query = mysql_query("SELECT * FROM `userstorage` WHERE `username` = '$username'");
$checkname = mysql_num_rows($query);
if($checkname >= 1) {
echp ("This username is currently in use!");
exit();
} else {
echo ("Whoops!");
}
Try that.

[redtom]

$username = silence($_POST['username']);
$query = mysql_query("SELECT * FROM `userstorage` WHERE `username` = '$username'");
$checkname = mysql_num_rows($query);
if($checkname >= 1) {
echp ("This username is currently in use!");
exit();
} else {
echo ("Whoops!");
}
Try that.

echp thats a new one :P

[Calon]

fixed.

Thanks :)

[Decode]

$username = silence($_POST['username']);

$query = mysql_query( "SELECT `username` FROM `userstorage` WHERE username = '$username'" );
$checkname = mysql_num_rows($query);
if($checkname === 1){

echo 'This username is currently in use!';
exit();

}
else {
echo "Woops";
}


EDIT: oh allready fixed

[Excellent]

echp thats a new one :PYa' I heard it was some new kind of function for sending out printed data!