'999' and company_id=1"; $sql="select * from itemmaster where item_id=133787"; $resulta = $awconn->query($sql); while($rowa = $resulta->fetch_assoc()) { $language=$rowa["item_desc"]; } //echo $rowa["item_id"]; $code=133787; //$language="abcd"; $official="PCS"; $percent=2; $grp=101; $sql1="INSERT INTO mydbtest (code,name,uom,groupcode,qty) VALUES (?, ?, ?, ? ,? )"; //$stmt = $conn->prepare($sql1); //$stmt->bind_param('sssds', $code, $language, $official, $grp, $percent); /* $code = $rowa["item_id"]; $language = $rowa["item_desc"]; $official = $rowa["uom_code"]; $percent = $rowa["op_2018"]; $grp=$rowa["group_code"]; */ $code=51294; //$language="abcd"; echo $language; $sql1="update mydbtest set name=? where code=?"; $stmt = $conn->prepare($sql1); $stmt->bind_param('ss', $code, $language); $stmt->execute(); //$sql1="INSERT INTO mydbtest VALUES ('".$rowa["item_id"]."','".$rowa["item_desc"]."','".$rowa["uom_code"]."',".$rowa["op_2018"].")"; //echo $sql1; //if (mysqli_query($conn, $sql1)) { // echo "New record created successfully"; //} else { // echo "Error: " . $sql . "
" . mysqli_error($conn); //} printf("%d row inserted.\n", $stmt->affected_rows); // } ?>