[Resolved] help w/ mysql_num_rows

[PHP_apprentice]

I keep getting an invalid argument error from my webserver when it tries to parse the:

mysql_num_rows($result);

Here is the block of code that it is contained in:

$query = "SELECT * FROM emplyee WHERE user_id = '$u' and pass = '$p'";

$result = mysql_query($query, $db);

if (mysql_num_rows($result) > 0 ){

echo'You have logged in successfully';

}

I am thinking that it may have something to do with the query but I don't know.

Thanks for the help

[OhLordy]

where do you get the variables $u and $p from?

[PHP_apprentice]

The $u and the $p are variables that I set in an

IF conditional just above it from the form as seen below:

if (empty($_POST['user_id']) && empty($_POST['pass_word'])){

echo'Please Login! If you are experiencing problems contact<br>a system administrator.  Thank you!<br><br>';
		echo'<a href="login.php">Return to Login!</a>';
	}else{
	$u = escape_data($_POST['user_id']);
	$p = escape_data($_POST['pass_word']);

echo'Welcome to the members site&nbsp;', $u;
}

[OhLordy]

a couple of things you can try,
echo the query to see if the database is getting what you expect,
add or die(mysql_error()); after the mysql_query() statement.
HTH
Rob

[cl_stef]

I agree with ohLordy, most of the times this error happens because the request is incorrect and returns an invalid result which can't be used as an argument for mysql functions.

You should ensure that your request is correctly processed by your mysql engine, simply echo $query and copy/paste the content into phpmyadmin (if you use it) or use mysql_error() to retrieve the error message.

(and I noticed that you use the "emplyee" as the table name, isn't it "employee" actually? That's just an idea 🙂 )

[PHP_apprentice]

In the end it proves to be human error

Maybe I should let the hard drive rest a little from time to time.

Thanks for the help