[SOLVED] Warning: mysql_num_rows(): supplied argument is not a valid MySQL result??

[shadiadiph]

MM sorry for a simple question but I have just stopped using my dbclass file and want to do a new site without it.

 

I keep getting the same error??

 

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

 

$checkuser = "select userID from usertbl where username='$username'";
$temps	   = mysql_query($checkuser);
$usertotal  = mysql_num_rows($temps);

 

to me it looks ok but obviously it isn't as i said i have been using a DB class until now so I am not sure. I want to stop using the class as there appear to be a few errors in the class.php

[MasterACE14]

change this line...

$temps	   = mysql_query($checkuser);

to...

$temps	   = mysql_query($checkuser) or die(mysql_error());

 

see what turns up

[shadiadiph]

ok thanks