Undefined variable: numrows in C:\xampp\htdocs\csrc\Untitled-1.php on line 16

[nhirene]

$query = mysql_query("SELECT * FROM users WHERE username='$username'");
	$db_rows= '';
	if ($numrows!=0)
	{
		while ($row = mysql_fetch_assoc($query))
		{
			$dbusername = $row['username'];
			$dbpassword = $row['password'];
		}
		//check to see if match!;
		if ($username==$dbusername&&$password==$dbpassword)
		{
			//echo "You're IN!";
			header("location: main.php");
			$_SESSION['username']=$dbusername;
		}
		else
			echo "Incorrect password!";
		
	}
	else

[Rabbit]

Please use code tags when posting code or formatted data.

The error message is pretty clear. You use a variable that you didn't declared.

[Dormilich]

this whole code is much too complicated (logic-wise). if you want to know, if a certain password matches a certain existing user, ask the DB that directly. i.e.

SELECT COUNT(*) FROM table WHERE username = ? AND password = ?