b.item_code AND auto_datetime_insert>='2022-11-14' ORDER BY store_line_item_no "; $resulta = $conn->query($sql); while($rowa = $resulta->fetch_assoc()) { // $cmpn=$rowa["company_id"]; $sql1="update scm_sr_line_item set item_code='".$rowa["gitc"]."' where store_line_item_no=".$rowa["store_line_item_no"] ; echo $sql1; if (mysqli_query($conn, $sql1)) { echo "New record created successfully"; //} else { // echo "Error: " . $sql . "
" . mysqli_error($conn); } }