Mysqli_num_rows() expects parameter 1 to be mysqli_result boolean given in

See more:

PHP

include('dbcon.php');


if(isset($_POST['login']))
{
$username = $_POST['uname'];
$password = $_POST['pass'];
$qry="SELECT * FROM 'admin' WHERE 'username'='$username' AND 'password'='$password'";
$run=mysqli_query($con,$qry);
$row=mysqli_num_rows($run);
if($row<1)
{
?>

alert('username or password not match!!');
window.open('login.php','_self');

<?php
}
else
{
$data=mysqli_fetch_assoc($run);
$id=$data['id'];
echo "id = ".$id;

What I have tried:

include('dbcon.php');


if(isset($_POST['login']))
{
$username = $_POST['uname'];
$password = $_POST['pass'];
$qry="SELECT * FROM 'admin' WHERE 'username'='$username' AND 'password'='$password'";
$run=mysqli_query($con,$qry);
$row=mysqli_num_rows($run);
if($row<1)
{
?>

alert('username or password not match!!');
window.open('login.php','_self');

<?php
}
else
{
$data=mysqli_fetch_assoc($run);
$id=$data['id'];
echo "id = ".$id;