Add Product
Brand Name
Generic Name
Category / Description
Supplier
Date Received
Expiry Date
Original Price
Issuance Price
QTY
Qty Left
Total
Action
prepare("SELECT *, price * qty as total FROM products ORDER BY product_id DESC"); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ $total=$row['total']; $availableqty=$row['qty']; if ($availableqty < 10) { echo '
'; } else { echo '
'; } ?>