无法登录到相应的页面

Question

I have created the below login function and called the same at another page as given below. But don't know why it is not working for me.

function auth_check_user1($login, $password, $agent )
{
  $query = 'SELECT * FROM ' . USERS_TABLE . ' WHERE login = "' . $login . '" AND password ="' . $password . '" AND user_category ="' . $agent . '"  LIMIT 1';

  $r = $db->query ($query); 

  if ($db->numrows($r)==1) 
  {
     $logged = TRUE;
  } 
  else  
  {
     $logged = FALSE;
  }
  return $logged;
}


if (auth_check_user1($session->fetch('login'), $session->fetch('password'), $session->fetch('agent')) )
{

   $query= 'SELECT first_name,id FROM ' . USERS_TABLE . ' WHERE approved = 1 AND login = "' . $session->fetch('login') . '" LIMIT 1';

   $r = $db->query( $query);

   <?php echo URL; ?>/login_user.php"><?php echo $lang['Menu_User_Login']; ?>
   <?php echo URL; ?>/index.php?req=logout"><?php echo $lang['Logout']; ?>

}

Answer 1

if ($db->numrows($r)==1) { $logged = TRUE;

Shouldn't it be > num_rows?