DaniWeb Forum Index > Web Development > PHP

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

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2009

Posts: 1

Reputation: JackSkylar is an unknown quantity at this point

Solved Threads: 0

JackSkylar JackSkylar is offline

Offline

Newbie Poster

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

Nov 11th, 2009

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:

 Help with Code Tags 
 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

•

Join Date: May 2008

Posts: 113

Reputation: Merlin33069 is an unknown quantity at this point

Solved Threads: 4

Merlin33069 Merlin33069 is offline

Offline

Junior Poster

-1

Nov 11th, 2009

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

Do you geek alone?

<<TimmCo>> Custom Computers

~Executive

•

Join Date: Sep 2009

Posts: 557

Reputation: network18 is an unknown quantity at this point

Solved Threads: 64

network18

Offline

Posting Pro

Nov 11th, 2009

•

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:
Help with Code Tags

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-

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$emailCHecker = eregi_replace("`", "", $emailCHecker);
$emailCHecker = eregi_replace("`", "", $emailCHecker);

The proper way to handle the num_rows -

 Help with Code Tags 
 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); }

"The discipline of writing something down is the first step towards making it happen."

follow me on twitter

•

Join Date: Apr 2005

Posts: 1,430

Reputation: ShawnCplus is a glorious beacon of light

Solved Threads: 232

ShawnCplus ShawnCplus is offline

Offline

Code Monkey

Nov 11th, 2009

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

GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.