Find the listing of customers who did not make purchases during the invoicing pe
ID: 3648594 • Letter: F
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); }