I am getting this error in my script: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\Server\SERVER\root\regcheck.php on line 46
And here is my code:
[php]
<?php if( isset( $_POST['user'] ) && isset( $_POST['pass'] ) && isset( $_POST['email']) && isset( $_POST['age'] ) ) { if( strlen( $_POST['user'] ) < 3 ) { echo "Username Must Be More Than 3 Characters."; } elseif( strlen( $_POST['pass'] ) < 4 ) { echo "Password Must Be More Than 4 Characters."; } elseif( strlen( $_POST['email'] ) < 1 ) { echo "Email must be Valid"; } elseif( strlen( $_POST['age'] ) ) { echo "You must be 13 years of age or older."; } elseif( $_POST['pass'] == $_POST['user'] ) { echo"Username And Password Can Not Be The Same. Security risks."; } else { include( 'database.php' );
$email = mysql_real_escape_string( $_POST[‘email’] );
$age = mysql_real_escape_string( $_POST[‘age’] );
$username = mysql_real_escape_string( $_POST[‘user’] );
$password = md5( $_POST[‘pass’] );
//Error area
$sqlcheckforduplicate = “SELECT username FROM members WHERE username = '”. $username ."’";
if ( mysql_num_rows( mysql_query( ‘sqlcheckforduplicate’ ) ) == 0 )
{
$sqlRegUser = “INSERT INTO
members( email, age, username, password )
VALUES(
'”. $email ."’,
‘". $age ."’,
‘". $username ."’,
‘". $password ."’
)";
// End error area
if( !mysql_query( $sqlRegUser ) )
{
echo “You Could Not Register Because Of An Unexpected Error.”;
}
else
{
echo “You Are Registered And Can Now Login”;
$formUsername = $username;
header (‘location: register_success.php’);
}
}
else
{
echo “The Username You Have Chosen Is Already Being Used By Another User. Please Try Another One.”;
$formUsername = $username;
}
}
}
else
{
echo “You Could Not Be Registered Because Of Missing Data.”;
}
?>
Can anybody help me?