///////////////////////////////////Model Sc insert $result50 = mysqli_query($conn,"SELECT * FROM Model_SCno1 " ) or die(mysqli_error()); while($row50 = mysqli_fetch_array( $result50 )) { $linenoo=$row50['LineNo']; $Model_No=$row50['Model_No']; $Model_Name=$row50['Model_Name']; $Sc_No=$row50['Sc_No']; $Seq_No=$row50['Seq_No']; $mdlscno1=$row50['mdlscno1']; $ISM=$row50['ISM']; $Color=$row50['Color']; $Size=$row50['Size']; $OPA1=$row50['OPA1']; $Part_ID1=$row50['Part_ID1']; $Part_ID2=$row50['Part_ID2']; $Part_ID3=$row50['Part_ID3']; $TC=$row50['TC']; $FrameColour=$row50['FrameColour']; $ForkColour=$row50['ForkColour']; $Quantity=$row50['Quantity']; $Pc1_prc=$row50['Pc1_prc']; $scprc=$row50['UnitPrice']; //$linenoo=$row50['LineNo']; $result501 = mysqli_query($conn,"SELECT * FROM PC_Item where SC_No='$Sc_No' and PC_No='1' And Seq_No='$Seq_No' AND Model_No='$Model_No' " ) or die(mysqli_error()); $row501 = mysqli_fetch_array( $result501 ); $pcprc=$row501['Price']; $sqlstr11 = "INSERT INTO Model_SCno(Model_No,Model_Name,Sc_No,Seq_No,mdlscno1,LineNo,ISM,Color,Size,OPA1,Part_ID1,Part_ID2,Part_ID3,TC,FrameColour,ForkColour,Quantity,Pc1_prc,sc_prc) VALUES('".$Model_No."','".$Model_Name."','".$Sc_No."','".$Seq_No."','".addslashes($mdlscno1)."','".$linenoo."','".addslashes($ISM)."','".$Color."','".addslashes($Size)."','".$OPA1."','".$Part_ID1."','".$Part_ID2."','".$Part_ID3."','".$TC."','".$FrameColour."','".$ForkColour."','".$Quantity."','".$pcprc."','".$scprc."')"; //echo $sqlstr11; //echo $sqlstr11; $result11 = mysqli_query($conn,$sqlstr11); } ?>