Need help with this error: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\wamp64\www\ananas\tadilat.php on line 14

See more:

PHP

MySQL

errors

error-handling

Here is my code:

The error says it is on line 13. Line 13 is where this code is at:

if (mysqli_num_rows($stock_query)==0) {

.

<?php
    include("dbconnect.php");

    //if categoryID is not set, redirect back to index page
    if(!isset($_GET['tadilatID'])) {
      header("Location:index.php");
    }
// Select all hizmetveren items belonging to the selected categoryID
  $stock_sql="SELECT usta.ustaID, usta.namelastname, usta.email, usta.phonenumber, usta.website, tadilat.name AS tadname FROM usta JOIN tadilat ON usta.tadilatID=tadilat.tadilatID WHERE usta.tadilatID=".$_GET['tadilatID'];
  if($stock_query=mysqli_query($dbconnect,$stock_sql)) {
    $stock_rs=mysqli_fetch_assoc($stock_query);
    
  }
  ---->>>> Line 13: Error Line -> if (mysqli_num_rows($stock_query)==0) {
    echo "Pek Yakinda Hizmetinizde";
  } else {
    ?>

      <h1><?php echo $stock_rs['tadname']; ?></h1>
    <?php do {
      ?>
<style>
.item{
line-height: 0.2;
width: 300px;
}
</style>
<h3>

        <div class="item">
          <a href="index.php?page=item&ustaID=<?php echo $stock_rs['ustaID']; ?>"><p><?php echo $stock_rs['namelastname']; ?></p>
          <p>E-Mail:🌐<?php echo $stock_rs['email']; ?></p>
          <p>Telefon: 📞<?php echo $stock_rs['phonenumber']; ?></p>
          <p>Website: 🌐<?php echo $stock_rs['website']; ?></p></a>
        </div>
        <hr>
    <?php

    }while($stock_rs=mysqli_fetch_assoc($stock_query));
    ?>

<?php
  }
?>

What I have tried:

I tried changing line 13 to ==1 instead of ==0. Or tried to switch else code with if else code. For example if previously it was: if x, else y, I switched it to if y, else x. Didn't work.

I have no idea at this point. Please help! Thank you very much.