Order Id :
Date :
0){
while($set_dist=mysqli_fetch_assoc($get_dist)){
$get_ref = mysqli_query($conn, "SELECT * FROM tbl_confirmorder where orderid='".$set_dist['ref_id']."'");
$set_ref = mysqli_fetch_assoc($get_ref);
$get_tot = mysqli_query($conn, "SELECT sum(totprice) as totprice FROM tbl_order where orderid='".$set_dist['ref_id']."'");
$set_tot = mysqli_fetch_assoc($get_tot);
echo $set_ref['refid'].' = '.$set_tot['totprice'].'
';
}
}
?>