									<?php
									//$order_id=$_GET['id'];
					
								


									$sqlxy = "SELECT id, (select product_name from products where id=sales_details.product_id)as product_name, quantity,selling_price, (select price from products where id=sales_details.product_id)as unit_price, (select Symbol from units where UnitID=(select Units from products where id=sales_details.product_id ))as units  from sales_details where order_id='$iddx'";
$resultp = mysqli_query($conn, $sqlxy);

// if (mysqli_num_rows($resultp) > 0) {

?>
									<table>
						              
						              <tbody>
						              <?php
						                  // output data of each row
    while($rown = mysqli_fetch_assoc($resultp)) {
?>
<tr>
						                  			                  
						                  <td width="40%"><?php echo $rown['product_name']; ?></td>
						                  <td width="20%"><?php echo $rown['quantity']." ".$rown['units']; ?></td>
						                  <td width="20%"><?php echo $rown['selling_price']; ?></td>
						                  <td width="20%"><?php echo $rown['quantity']*$rown['selling_price']; ?></td>
						                  
						                </tr>
						                <?php
       
    }
// } else {
//     echo "No results";
// }
?>
						                
						                
						              </tbody>
						            </table>