'; ?>

0){ while($set_user = mysqli_fetch_assoc($get_user)){ $get_video = mysqli_query($conn,"select * from tbl_order td inner join shop_product sp on td.productid = sp.product_id where sp.v_s =1 and td.user_id = '".$set_user['user_id']."'"); while ($get_fetch = mysqli_fetch_array($get_video, MYSQLI_ASSOC)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id = '$get_fetch[product_id]'"); $get_product = mysqli_fetch_array($get_prod, MYSQLI_ASSOC); echo strtoupper($get_product['name']).' '.date('d-m-Y',strtotime($get_fetch['orderdate'])).'

'; ?>