<?php
// Sets to unlimited period of time
ini_set('max_execution_time', 0);
?>
<?php



include("db.php");


$sql="
select a.itemid,b.item_desc from 
(
select distinct(item) itemid from tbl_proc_po_detail 
) a, itemmaster b where a.itemid=b.item_id
";
$resulta = $conn->query($sql);


while($rowa = $resulta->fetch_assoc()) 
 {
$language=$rowa["item_desc"];
$code=$rowa["itemid"];

$sql1="update tbl_proc_po_detail  set description=? where item=?";
$stmt = $conn->prepare($sql1);
$stmt->bind_param('ss',  $language,$code);
echo $code."-".$language;


$stmt->execute();





}