format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $getItems = mysql_query("SELECT * FROM `prf_items` WHERE `deleted` = 0 AND `item_description`!=''"); while($row=mysql_fetch_array($getItems)){ $itemID = $row['id']; $itemDesc = TRIM($row['item_description']); //echo ''; $getIndexCount = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_detl` WHERE `item_description`='$itemDesc'"),0); $indexTotalCount = $indexTotalCount + 1; mysql_query("UPDATE `prf_request_detl` SET `sku_id`='$itemID' WHERE `item_description`='$itemDesc'"); $getIndexCount = 0; } echo ''; exit; } ?>