<?php 

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

$loop = $Mainclass->Fetch_multiple_data("gold_temp_product_master","*","SLN!=''");

foreach ($loop as $loop) {
	
$data = $Mainclass->Fetch_individual_data("design_code_master","*","ParentId='".$loop['ParentId']."'");


$Mainclass->Update_Data("gold_temp_product_master","ProductName='".$data['ProductName']."',HSNCode='".$data['HSNCode']."',GoldPurity='".$data['GoldPurity']."',StoneName='".$data['StoneName']."',No_Stone='".$data['No_Stone']."',Stone_Value='".$data['Stone_Value']."',DiamondQuality='".$data['DiamondQuality']."',DiamondColor='".$data['DiamondColor']."',DiamondType='".$data['DiamondType']."',No_Diamond='".$data['No_Diamond']."',Diamond_Value='".$data['Diamond_Value']."',SolitaireQuality='".$data['SolitaireQuality']."',SolitaireColor='".$data['SolitaireColor']."',SolitaireType='".$data['SolitaireType']."',No_Solitaire='".$data['No_Solitaire']."',Solitaire_Value='".$data['Solitaire_Value']."',MakingChargesType='".$data['MakingChargesType']."',MakingChargesValue='".$data['MakingChargesValue']."',WastageCost='".$data['WastageCost']."',Remark='".$data['Remark']."',has_stone='".$data['has_stone']."',has_diamond='".$data['has_diamond']."',has_solitaire='".$data['has_solitaire']."'","ParentId='".$data['ParentId']."'");


}

?>