format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $selItemDesc = mysql_escape_string($_POST['selItemDesc']); $ActionReferenceIDDescXX = mysql_escape_string($_POST['ActionReferenceIDDescXX']); mysql_query("UPDATE `prf_request_detl` SET `item_description`='$selItemDesc' WHERE `id`='$ActionReferenceIDDescXX'"); $getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$UpdatePRFReferenceNumber'"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getItemDetl)){ $count = $count + 1; ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Rec.#	REF. #	ITEM DESCRIPTION	UoM	QUANTITY	-
".strtoupper($row['header_ref_code'])."	".strtoupper($row['item_description'])."	".strtoupper($row['uom'])."	".strtoupper($row['quantity'])."

"; exit(); } ?>