Live Purchase Orders

num_rows > 0) { while ($row = $result->fetch_assoc()) { $statusClass = ($row["status"] == "Approved") ? "approved" : "pending"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } else { echo ""; } $conn->close(); ?>

PO Number	Product	Suggested Reorder	Total Cost	Status	Created By	Date	Action
" . htmlspecialchars($row["po_number"]) . "	" . htmlspecialchars($row["product_name"]) . "	" . (int)$row["suggested_reorder"] . " units	$" . number_format((float)$row["estimated_cost"], 2) . "	" . htmlspecialchars($row["status"]) . "	" . htmlspecialchars($row["created_by"]) . "	" . htmlspecialchars($row["created_at"]) . "	View PO
No purchase orders have been generated yet.