'; $get_pro = mysqli_query($conn, "SELECT tc.refid, ts.orderdate,sp.name,sp.product_url,ts.qty FROM tbl_confirmorder tc inner join tbl_order ts on tc.orid = ts.orderid inner join shop_product sp on ts.productid=sp.product_id where tc.orid = '$array'"); echo ''; while($get_c = mysqli_fetch_array($get_pro, MYSQLI_ASSOC)) { echo ''; } echo '

'.$get_c['name'].'

'.$get_c['product_url'].'

'.$get_c['qty'].'

'; } ?>