Error-supplied argument is not a valid MySQL

vishal_du123

please help me

require_once('clsConnect.php');
//Check User in Database
global $admin;
global $pwdadmin;
function fnUsrEnter($strSql)
{
$rs1 = mysql_query($strsql);
if(mysql_num_rows($rs1)>0)
{
while($row=mysql_fetch_array($rs1))
{
if($row['fldU_ID']=='$admin' and $row['fldPwd']=='$pwdadmin')
header("location:admlogin.php");
else
header("location:user.php");
}
}
}
global $user_tablename;
//making Connection.
if($_POST['cmdSubmit'] == 'Login')
{
$conn= new clsConnect();
$conn->fnConnect();

		$sql1 ="SELECT fldU_ID, fldPwd FROM ".$user_tablename." WHERE fldU_ID='".$_POST['txtUser_Id']."' AND fldPwd='".$_POST['txtPwd']."'";
		fnUsrEnter($sql1);
		$conn->fnClose();
}
else
	{
			echo $_POST['cmdSubmit']."<br><br><table align='right' border='0' width='300' height='50' class='err'=''><br><br>
			<tr><td bgcolor='#FFFFFF'>Invalid User--!<br>New User Please Sign Up---!<br></td></tr>
			</table>";	

	}

and Error is -
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\wamp\www\vblog1\userchk.php on line 9

NogDog

It almost certainly means your query could not be parsed/processed by MySQL, so mysql_query() returned boolean false instead of a resource ID. You should always check the result of any query and log an error if it fails. For quick-and-dirty debugging (but not for the final production version), you could do:

$rs1 = mysql_query($strsql) or die(mysql_error() . "<br />$strsql");

PS: Welcome to the forums, and in the future, please help us help you by using the [noparse]

...

[/noparse] bbcode tags around your code samples.