mysql_num_rows

[Attila]

Can someone please help me with this. It seams like every time I use mysql_num_rows I am always fighting with errors.
Here is my error.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in logonconfirm.php on line 9

Here is my code

$logon = logon;
$password = password;

$link = mysql_connect("localhost", "logon", "pass");
mysql_select_db("database", $link);

$name = mysql_query("SELECT name FROM member WHERE name =" .$logon, $link);
$num_rows = mysql_num_rows($name);

if ($num_rows <= 0)
	{
		echo "Your user name is not in the database.";
		exit;
	}
$password = mysql_query("SELECT password FROM member where password =" .$password, $link);
$password_rows = mysql_num_rows($password);

if ($password_rows <= 0)
	{
		echo "Your password is incorrect.";
		exit;
	}
?>

Can someone help?

[wilsonodk]

I think the problem is in your query strings,
mysql wants the value as a string so you have to suround the values with single quotes

// first query string
$name = mysql_query("SELECT name FROM member WHERE name = '$logon'", $link);

//second query
$password = mysql_query("SELECT password FROM member where password = '$password'", $link);

HTH

[Attila]

Thank you!! The bo bo is gone and the bandaid is off that fixed it!😃