Find the listing of customers who did not make purchases during the invoicing pe

Question

Find the listing of customers who did not make purchases during the invoicing period. Your output must match the output shown in Figure P7.40. Find the customer balance summary for all customers who have not made purchases during the current invoicing period. The results are shown in Figure P7.41. Create a query that summarizes the value of products currently in inventory. Note that the value of each product is a result of multiplying the units currently in inventory by the unit price. Use the ORDER BY clause to match the order shown in Figure P7.42.

Explanation / Answer

$query = "select * from CUSTOMER"; $result = mysql_query($query); while($row=mysql_fetch_array($result)){ $inv = $row["CUS_CODE"]; $query = "select * from LINE where CUS_CODE=$inv"; $result1 = mysql_query($query); while($row1 = mysql_fetch_array($result1){ $sum+=$row1[CUS_BALANCE]; } $query = "insert into TOTALS(CUS_CODE,Total) values($inv,$sum)"; mysql_query($query); }

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.