Question

我需要一些帮助。我从我的数据库中看到这一点:

SELECT DISTINCT 
    iwi.item Item, ppd.item_des Des, iwi.qty_on_hand QOH, iwi.qty_allocated QA, 
    iwi.qty_on_order QOO, iwi.min_qty Minimum, MAX(ppm.expected_date)Exp_Date
FROM inv_warehouse_items iwi, pur_po_master ppm, pur_po_detail ppd)
WHERE IWI.CO =  100 
AND iwi.item_key = ppd.item_key
AND ppm.po_key = ppd.po_key
AND iwi.warehouse =  01 
AND iwi.item IN ( BXHP335 ,
 BXHP435 ,
 BXHP535 ,
 BXHP644 ,
 BXHP743 ,
 BXHP965 ,
 BXHP10741 ,
 BXHP10748 ,
 BXHP1253 ,
 BXHP1257 ,
 BXHP121210 ,
 BXHP151410 ,
 BXHP16114 ,
 BXHP181411 ,
 BXHP241612 ,
 BX1195 ,
 BX6636 ,
 BXHP201512 ,
 BXHP1949 ,
 BXHP2015 ,
 BXHP201515 ,
 BXHP351011 ,
 BXHP241814 ,
 BXHP2257 ,
 BXHP1824 )

GROUP BY iwi.item, iwi.qty_on_hand, iwi.qty_allocated, iwi.qty_on_order, 
     iwi.min_qty, ppd.item_des
ORDER BY iwi.item"

而且,我需要与营地印刷。

Answer 1

我是否可以认为大会也希望这样做。

$query = "...";
$result = $mysqli_query($db, $query);
while($row = mysqli_fetch_assoc($result)) {
    print_r($row);
}

友情链接