Answered

Write a query to display the invoice number, line numbers, product SKUs, product descriptions, and brand ID for sales of sealer and top coat products of the same brand on the same invoice. Sort the results by invoice number in ascending order, first line number in ascending order, and then by second line number in descending order

Answer :

kendrich

Answer:

See explaination

Explanation:

$query = "select * from LGINVOICE";

$result = mysql_query($query);

while($row=mysql_fetch_array($result)){

$inv = $row["INV_NUM"];

$query = "select * from LINE_Num where INV_NUM=$inv";

$result1 = mysql_query($query);

while($row1 = mysql_fetch_array($result1){

$sum+=$row1[PROD_SKU];

}

$query = "insert into SEALER(INV_NUM,BRAND_ID) values($inv,$sum)";

mysql_query($query);

}

Other Questions