www.helpdeskreloaded.com

hi frnds
I have some error in following php codes at line no 9 please help me.
[color=blue][b]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource[/b][/color]

[code]

<?php
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>";

}
?>

[/code]


and error is -
[color=red][b]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\no links allowed\vblog1\userchk.php on line 9[/b][/color]

Hmm, first reactions :

This is not in the right section of the board.
And it doesn't seem to be a helpdeskreloaded file. Which means we can't help you since we do not know what the code is supposed to do.

if mysql is not enabled in the PHP.ini and setup correctly you will get that error message. Bosjvd is correct, you should post in the problems area please.

Thank you.

H.D.R. Forum Admin