Untitled

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:xampphtdocsresults.php on line 74

<?php

$server="localhost";
$username="root";
$password="";
$dbname="equipment";
$conn=mysqli_connect($server,$username,$password,$dbname);
$conn2=mysqli_connect($server,$username,$password,$dbname);

?>

<!doctype html>

<html>

<head>

<link rel="stylesheet" type="text/css" href="resultsstyle.css">
<link rel="icon" href="Icon.jpg">

<title>Search</title>

</head>

<body>

<div class="header">

<img class="icon" src="Icon.jpg">
<div class="search">Search </div>

</div>

<div class="select">Results </div>


<?php

if (isset($_POST['submit-search'])){
    $search=mysqli_real_escape_string($conn,$_POST['search']);
    $sql="SELECT * FROM bookings WHERE equipment LIKE'%$search%' OR start_time LIKE '%$search%'OR end_time LIKE '%$search%'OR selected_date LIKE '%$search%'";
    $result=mysqli_query($conn, $sql);
    $queryResult=mysqli_num_rows($result);

    if(empty($_POST['search'])){
        echo '<span class="empty">Search box was empty. Please try again.</span>';
    }else{

    if($queryResult>0){
        while($row=mysqli_fetch_assoc($result)){
            echo "
<span class='e'>Equipment: <span class='first'>".htmlspecialchars($row['equipment'])."</span></span><br>
<span class='bd'>Booking Date: <span class='second'>".htmlspecialchars($row['selected_date'])."</span></span><br>
<span class='st'>Start Time: <span class='third'>".htmlspecialchars($row['start_time'])."</span></span><br>
<span class='et'>End Time: <span class='fourth'>".htmlspecialchars($row['end_time'])."</span></span><br>
<span class='n'>Notes: <span class='fifth'>".htmlspecialchars($row['notes'])."</span></span><br><br><br><br>
";
    }
        }else{
        echo "<span class='none'>No results were found.</span>";

}
}
}
?>

<?php

if (isset($_POST['submit-search'])){
    $search=mysqli_real_escape_string($conn2,$_POST['search']);
    $sql="SELECT * FROM bookings2 WHERE room LIKE'%$search%' OR start_time LIKE '%$search%'OR end_time LIKE '%$search%'OR selected_date LIKE '%$search%'";
    $result=mysqli_query($conn2, $sql);
    $queryResult=mysqli_num_rows($result);

    if(empty($_POST['search'])){
        echo '<span class="empty">Search box was empty. Please try again.</span>';
    }else{

    if($queryResult>0){
        while($row=mysqli_fetch_assoc($result)){
            echo "
<span class='e'>Room: <span class='first'>".htmlspecialchars($row['room'])."</span></span><br>
<span class='bd'>Booking Date: <span class='second'>".htmlspecialchars($row['selected_date'])."</span></span><br>
<span class='st'>Start Time: <span class='third'>".htmlspecialchars($row['start_time'])."</span></span><br>
<span class='et'>End Time: <span class='fourth'>".htmlspecialchars($row['end_time'])."</span></span><br>
<span class='n'>Notes: <span class='fifth'>".htmlspecialchars($row['notes'])."</span></span><br><br><br><br>
";
}
    }else{
        echo "<span class='none'>No results were found.</span>";

}
}
}
?>