Help with User Logins

[JustWhatever]

I'm looking at various resources in order to understand how to create user logins for a website, but every time I try something goes wrong. Specifically...well below is my code, where specifically this line "$numrows = mysql_num_rows($query);" gives me the error "Warning: mysqli_stmt_num_rows() expects parameter 1 to be mysqli_stmt, string given" and I have no clue how to fix this. If someone could help it'd be greatly appreciated. Connection to the database works fine, it's that one line though that gives me grief.

$myusername = $_POST['username'];
	$mypassword = $_POST['pass'];
	
	if ($myusername && $mypassword) {
	$connection = @new mysqli($host, $username, $password, $db_name);
	if ($connection->connect_error) {
		die('Connect Error' . $connection->connect_error);
	} else {
		echo 'Successfully Connected to the Database';
		
		$query = "SELECT * FROM logins WHERE username = '$username'";
		
		$numrows = mysql_num_rows($query);
		
		if ($numrows !=0) {
			while($rows = mysql_fetch_assoc($query)) {
				$db_username = $row['username'];
				$db_password = $row['password'];
			}
			
			if ($myusername == $db_username && $mypassword == $db_password) {
				echo "Login Successful";
			} else {
				echo "The username and/or password were incorrect";
			}
			
		}
	}
	}

[jimr451]

You forgot to run:

$result = mysql_query($query); 

then call mysql_num_rows on $result.

-Jim