Page 1 of 1

mysql_num_rows Error

Posted: Thu Dec 30, 2010 8:19 pm
by brmcdani44
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:

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";
}

Re: mysql_num_rows Error

Posted: Thu Dec 30, 2010 11:59 pm
by anantha
you should not pass the sql query...you may do like this

$result=mysql_query($sql2);

then pass the $result to mysql_num_rows($result);

this should work...

Re: mysql_num_rows Error

Posted: Fri Dec 31, 2010 12:05 am
by tomindo
you need to fix sql2 like this

Code: Select all

$sql2="Select * from users WHERE email='".$email."'";

Re: mysql_num_rows Error

Posted: Fri Dec 31, 2010 8:27 am
by brmcdani44
Now I am getting this error

Call to undefined function mysql_qry()

Hmmm

Re: mysql_num_rows Error

Posted: Fri Dec 31, 2010 8:30 am
by Darhazer
brmcdani44 wrote:Now I am getting this error

Call to undefined function mysql_qry()

Hmmm
It's really obvious :) There is no function mysql_qry()
The function is mysql_query()

Re: mysql_num_rows Error

Posted: Fri Dec 31, 2010 11:37 am
by brmcdani44
Yeah I fixed it 2 seconds after I posted that
lol