I am getting this message for some reason
mysql_num_rows(): supplied argument is not a valid MySQL result resource
here is my code. It is used to check users screenname and passwords against the DB but it isn't working at all.
function db_connect()
{
$result = mysql_pconnect("localhost", "myname", "mypwd");
if (!$result)
return false;
if (!mysql_select_db("mydb", $result))
return false;
return $result;
}
function login()
// check username and password with db
// if yes, return true
// else return false
{
$username=$POST['username'];
$password=$POST['password'];
// connect to db
$conn = db_connect();
if (!$conn)
return false;
// check if username is unique
$result = mysql_query("select from 'users'
where username='$username'
and password='$password'");
if (mysql_num_rows($result)>0)
return true;
else
return false;
}
function check_admin($valid_user)
{
if (session_is_registered("valid_user"))
{
$db=db_connect();
$sql="select from 'users' where username='$valid_user' and admin='1'";
$result=mysql_query($sql);
if (mysql_num_rows($result)>0)
return true;
else
return false;
}
else
return false;
}
$username=$POST['username'];
$password=$POST['password'];
if($username && $password)
{
$result=login();
if($result)
{
$valid_user = $username;
$heading = "::Welcome $username";
$status = "Logged in as $valid_user";
if(!session_is_registered('valid_user'))
{
session_register('valid_user');
session_register('status');
if(check_admin($valid_user))
{
$admin="admin";
session_register('admin');
}
}
}
else
{
$heading = ":😛lease try Again";
$status = "You could not be logged in with the supplied information";
}
}
i have been running into trouble at the red text. It has given me error msg for both thoose lines. I know the db_connect works it works on other pages. so what could it be.
