User Authentication not working!

[JagXJ220]

I'm using this code to verify users from a form:

<?
session_start();
$login_result = mysql_query("SELECT * FROM members WHERE userid='$login_userid' AND userpass='$login_userpass'"); 
if (mysql_num_rows($login_result)==1) { 
$logged_in = "yes";
$logged_in_user = $login_userid;
$logged_in_pass = $login_userpass;
session_register('logged_in');
session_register('logged_in_user');
session_register('logged_in_pass');
}
?>

When I try to login it gives me this error:

Warning: Supplied argument is not a valid MySQL result resource in /home/super/public_html/phpnetwork/login.php on line 4

I can't figure out what's going on. Could someone help me out?

[DarkMonkey]

Well you'll need to actually connect to mysql and your database first... Normally I would assume you have done that, but if the error was line 4 then that fits with your code... So...

[JagXJ220]

Actually, that code was in its own file which was included in my main page using the require() function. In the main page, a connection to the database is already established.

[Robo]

Try using include() instead of require()

[DarkMonkey]

Right, okay, my first reaction, that's all