query($sql); $totalInvoices = 0; if ($result && $result->num_rows > 0) { $row = $result->fetch_assoc(); $totalInvoices = $row['total']; } // Get recent invoices $sql = "SELECT id, invoice_no, invoice_date, consignee_name FROM challan_invoices ORDER BY created_at DESC LIMIT 10"; $result = $conn->query($sql); ?>

Total Invoices

Recent Invoices

Back

num_rows > 0): ?> fetch_assoc()): ?>

Invoice No.	Date	Consignee	Actions
			View

No invoices found. Create your first invoice.