Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\loginb\code.php on line 14
My Code is the following , can someone please help me to fix this error
<?php
require_once "connection.php";
$message = "";
$role= "";
if(isset($POST["Submit"]))
{
$username = $POST["username"];
$password = $_POST["password"];
$query = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result =mysqli_query($conn,$query);
if(mysqli_num_rows($result) > 0) -----------------------------------------line 14
{
while ($row = mysqli_fetch_assoc($result))
{
$role = $row["Role"];
}
}
}
?>