Return HTML Element from PHP Script Response based on Condition

one text

Solution:

I changed == to <= which now only prints what I need to print

<?php

include 'DB.php';

$SQL = "SELECT Product_Name, Stock_Count, Stock_Remaining FROM Products WHERE Stock_Count > 0";

$result = $conn->query($SQL);

if ($result->num_rows > 0 ){
    while ($row = $result->fetch_assoc()){
       if ($row["Stock_Count"] / 2 <= $row["Stock_Remaining"] ){
           echo "<p>$row[Product_Name] is below half capacity</p>";
       }else {
           "<p>[$row[Product_Name]]: No New Notifications</p>";

       }
    }
}else {
    echo "No Products Found";
}