TalkPHP - View Single Post - Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Hanzo · 08-04-2012, 03:18 AM

You're also assigning $numrows a value of 0 in your conditional. Know that if you don't need the else statement, just omit it. :)

Try this:

PHP Code:


			
// new sql to pull associated products for seleceted family 

 $restwoway = mysql_query("SELECT * FROM members ORDER BY name"); 

$numrows=mysql_num_rows($restwoway);  

if($numrows===0){

 echo "Invalid entry"; 

}

08-04-2012, 03:18 AM	#3 (permalink)
Hanzo The Visitor Join Date: Aug 2012 Location: 127.0.0.1 Posts: 2 Thanks: 0	You're also assigning $numrows a value of 0 in your conditional. Know that if you don't need the else statement, just omit it. :) Try this: PHP Code: `// new sql to pull associated products for seleceted family $restwoway = mysql_query("SELECT * FROM members ORDER BY name"); $numrows=mysql_num_rows($restwoway); if($numrows===0){ echo "Invalid entry"; }`