I keep getting this message
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/j/a/c/jackattacksite/html/register.php on line 80
Here's the code:
// Connect to database
include_once "scripts/connect_to_mysql.php";
$emailCHecker = mysql_real_escape_string($email1);
$usernameChecker = mysql_real_escape_string($username);
$emailCHecker = eregi_replace("`", "", $emailCHecker);
$usernameChecker = eregi_replace("`", " ", $usernameChecker);
// Database duplicate e-mail check setup for use below in the error handling if else conditionals
$sql_email_check = mysql_query("SELECT email FROM myMembers WHERE email='$emailCHecker'");
$email_check = mysql_num_rows($sql_email_check);
$sql_username_check = mysql_query("SELECT username FROM myMemebers WHERE username='$usernameChecker'");
$username_check = mysql_num_rows($sql_username_check);
I checked if the variables matched, but they seemed to match. Thanks to anyone who helps