<?php

include("db_connection.php");
$Mainclass=new DB_Controller();

?>

<table cellpadding="2" cellspacing="2" border="1">
    
<tr>

<td>SLN</td>

<td>Product Id</td>

<td>Gold Weight</td>

<td>Stone</td>
<td>Stone Qty</td>

<td>Diamond Type</td>
<td>Diamond Quality</td>
<td>Diamond Color </td>
<td>Diamond Size </td>
<td>Diamond Quantity</td>


<td>Solitaire  Type</td>
<td>Solitaire  Quality</td>
<td>Solitaire  Color </td>
<td>Solitaire  Size </td>
<td>Solitaire  Quantity</td>

</tr>

<?php

$fetch_temp_product=$Mainclass->Fetch_multiple_data("gold_temp_product_master","*","SLN>0 and add_to_product='No' and igi_updation='No' and confirm='Yes' ORDER BY SLN DESC");

$i = 1; 

 foreach ($fetch_temp_product as $temp_product)
{

?>

<tr>
    


<td> <?php echo $i; ?></td>
<td> <?php echo $temp_product['Product_Id']; ?></td>
<td> <?php echo $temp_product['GoldWeight']; ?></td>
<td> <?php echo $temp_product['StoneName']; ?></td>
<td> <?php echo $temp_product['No_Stone']; ?></td>
<td> <?php echo $temp_product['Diamond_Creation_Type']; ?></td>
<td> <?php echo $temp_product['DiamondQuality']; ?></td>
<td> <?php echo $temp_product['DiamondColor']; ?></td>
<td> <?php echo $temp_product['DiamondType']; ?></td>
<td> <?php echo $temp_product['No_Diamond']; ?></td>
<td> <?php echo $temp_product['Solitaire_Creation_Type']; ?></td>
<td> <?php echo $temp_product['SolitaireQuality']; ?></td>
<td> <?php echo $temp_product['SolitaireColor']; ?></td>
<td> <?php echo $temp_product['SolitaireType']; ?></td>
<td> <?php echo $temp_product['No_Solitaire']; ?></td>
<?php

$i++;

} 

?>


</tr>



</table>
