Invoice List

Senarai Invois

0) { // Display the invoices in a table echo "

Invoice List for ClientRegNo: $custname

"; echo ""; echo ""; $owing = 0; while ($row = mysqli_fetch_assoc($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; if ($row['totamt'] - $row['totrec'] == 0) { echo ""; } else { echo ""; $owing += $row['totamt'] - $row['totrec']; } echo ""; } echo "

Invoice No.	Invoice Due Date	Total Amount	Total Received	Status
" . $row['invno'] . "	" . $row['invduedate'] . "	" . number_format($row['totamt'], 2, '.', ',') . "	" . $row['totrec'] . "	Closed	Open

"; echo "

Amount owing by $custname: " . number_format($owing, 2, '.', ',') ."

"; } else { // If no invoices are found, display a message echo "

No invoices found for ClientRegNo: $custname

"; } } ?>