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..?

[Calon]

Change the 0 to a 1..?

Still 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

[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

Ya' I heard it was some new kind of function for sending out printed data!