A fatal MySQL error occured.\n
Query: " . $qry . "
\nError: (" . mysql_errno() . ") " . mysql_error()); $count = mysql_num_rows($result); ?> if($count>0) { ?>
Items to invoice
Customer
Description
Invoicelinedate
Amount
Charge
// Loop through them while ($invoiceline = mysql_fetch_array($result)) { echo "
"; echo "
"; echo "
".$invoiceline["customername"]."
"; echo "
".$invoiceline["description"]."
"; echo "
".$invoiceline["invoicelinedate"]."
"; echo "
".$invoiceline["amount"]."
"; echo "
".$invoiceline["charge"]."
"; echo "
\n"; } ?>
Create invoice number
} ?>
One-time invoice line
Customer
Description
Invoicelinedate
Amount
Charge
---Select---
// Get all customers $qry = "SELECT * FROM ".$opts['cu']." ORDER BY customername"; $result = mysql_query($qry) or die("
A fatal MySQL error occured
.\n
Query: " . $qry . "
\nError: (" . mysql_errno() . ") " . mysql_error()); while($customer = mysql_fetch_array($result)) { echo "
".$customer["customername"]."
\n"; } ?>
">
Add new invoice line