mysql_num_rows Error
Posted: Thu Dec 30, 2010 8:19 pm
I keep getting this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
On this line of code:
$verifynotregistered = mysql_num_rows($sql2) or die(mysql_error());
Can someone please give me a hand. Thanks in advance!
Attached is the code block:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
On this line of code:
$verifynotregistered = mysql_num_rows($sql2) or die(mysql_error());
Can someone please give me a hand. Thanks in advance!
Attached is the code block:
Code: Select all
$activationKey = mt_rand() . mt_rand() . mt_rand() . mt_rand() . mt_rand();
$firstname = mysql_real_escape_string($_POST[firstname]);
$lastname = mysql_real_escape_string($_POST[lastname]);
$username = mysql_real_escape_string($_POST[username]);
$password = mysql_real_escape_string($_POST['password']);
$email = mysql_real_escape_string($_POST[email]);
$sql="INSERT INTO users (firstname,lastname,username, password, email, activationkey, status) VALUES ('$firstname', '$lastname', '$username', '$password', '$email', '$activationKey', 'verify')";
$sql2="Select * from users WHERE email='$email'";
$verifynotregistered = mysql_num_rows($sql2) or die(mysql_error());
if ($verifynotregistered == 1)
{
echo "You have already registered,Click here to recover your password";
}