<?php
        $urunlerSorgu = $db->prepare("SELECT s.STOCKNO FROM ORDERSITEM AS oi LEFT JOIN STOCK AS s ON s.STOCKID = oi.STOCKID WHERE oi.RECEIPTID = :receipt_id ORDER BY ITEMNO ASC");
        $urunlerSorgu->execute(['receipt_id' => $siparisigetir['RECEIPTID']]);
        $urunler_urunkodlari = $urunlerSorgu->fetchAll(PDO::FETCH_COLUMN);
    //        echo "<pre>";
    //            print_r($urunler_urunkodlari);
    //        echo "</pre>";
?>