'N' AND md1.company_id in (1,2,3)"; //$sql="select a.*,b.material_inventory_id,b.item bitem,b.inward from scm_issue_hdr a, tbl_proc_material_inventory b //where a.sr_no=b.inward and a.sr_line_id=b.inward_detail //"; $resulta = $conn->query($sql); while($rowa = $resulta->fetch_assoc()) { $sql1="update scm_issue_hdr set item_id=".$rowa["bitem"].",material_inventory_id=".$rowa["mt_inv_id"].",inward=".$rowa["minward"].",.lot_no=".$rowa["rec_id"]." where issue_no=".$rowa["issue_no"] ; if (mysqli_query($conn, $sql1)) { echo "New record created successfully"; //} else { // echo "Error: " . $sql . "
" . mysqli_error($conn); } echo $sql1; }