Ad:

PHP Discussion Thread
Unsolved
Views: 841

Nov 11th, 2009

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Expand Post »

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:

php Syntax (Toggle Plain Text)
 // 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);
 // 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

Similar Threads

JackSkylar

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2009

Permalink

Nov 11th, 2009

-1

Re: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

i believe this generally means that the search of the database is not returning any result... or something along those lines...

you could try adding a catch after the mysql_query's

something like

$sql_email_check = mysql_query("SELECT email FROM myMembers WHERE email='$emailCHecker'") OR die('Error in mysql syntax: ' . mysql_error());

but gl getting this fixed

Merlin33069

Reputation Points: 10

Solved Threads: 4

Junior Poster

Offline

126 posts
since May 2008

Permalink

Nov 11th, 2009

Re: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Click to Expand / Collapse Quote originally posted by JackSkylar ...

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:
php Syntax (Toggle Plain Text)
 // 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);
// 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

are you sure you want to do this way-

PHP Syntax (Toggle Plain Text)
$emailCHecker = eregi_replace("`", "", $emailCHecker);
$emailCHecker = eregi_replace("`", "", $emailCHecker);

The proper way to handle the num_rows -

PHP Syntax (Toggle Plain Text)
$email_check = 0;
if(mysql_num_rows($sql_email_check) !='' || mysql_num_rows($sql_email_check) !=FALSE)
{
$email_check = mysql_num_rows($sql_email_check); }
$email_check = 0;
if(mysql_num_rows($sql_email_check) !='' || mysql_num_rows($sql_email_check) !=FALSE)
{
$email_check = mysql_num_rows($sql_email_check); }

network18

Reputation Points: 29

Solved Threads: 76

Practically a Master Poster

Offline

616 posts
since Sep 2009

Permalink

Nov 11th, 2009

Re: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Don't use ereg (http://php.net/preg), and read the giant READ ME FAQ at the top of the PHP forums then come back here and ask your question again

ShawnCplus

Sponsor

Reputation Points: 520

Solved Threads: 268

Code Monkey

Offline

1,564 posts
since Apr 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: select one checkbox instedof select multiple checkboxes

Next Thread in PHP Forum Timeline: Global Class Variables.

DaniWeb Message

Cancel Changes

User Name
Password