[SOLVED] Problems with outputs

[plznty]

if ( $_GET['view'] == 'process' )
{
    // Gathered Information
    $Zuser = $_POST['user'];
    $pass = $_POST['pass'];
    $cash = $_POST['cash'];
    $Zquestion = $_POST['question'];
    $Zanswer = $_POST['answer'];

    // Lowercase gathered information
    $user = strtolower($Zuser);
    $question = strtolower($Zquestion);
    $answer = strtolower($Zanswer);

    // Check whether $user exists or not
    $sql = "SELECT * FROM `users` WHERE `username` = '$user'";
    $rs = mysql_query($sql) or die(mysql_error());

    // If number of rows returned is more than 1, it means username is duplicated
    if ( mysql_num_rows($rs) > 1 ) {
        echo "Duplicate username!";
    }
    else {
        mysql_query("INSERT INTO users
   (username, password, money, current, rank, secretquestion, secretanswer) VALUES('$user', '$pass', '$cash', '0', 'noob', '$question','$answer' ) ")
        or die(mysql_error());

        echo "User Created!";
    }

}

It doesnt ever say "Duplicate username" when there is already a user in the sql table. It only works with user created. Otherwise if there is a duplicate it shows "Duplicate entry '' for key 2"

[PFMaBiSmAd]

if ( mysql_num_rows($rs) > 1 ) {

 

That's because you are testing if there is more than one row from the SELECT query. If a user name already exists there would be one row, not more than one row.

[plznty]

I was looking at that earlier. Thanks !