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'])){ $getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$uReferenceID' AND `comp_id`='$prfCompanySelected'"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getItemDetl)){ $count = $count + 1; $itemClassID = $row['item_class']; $itemClassDes = mysql_result(mysql_query("SELECT `item_category` FROM `prf_item_category` WHERE `id`='$itemClassID'"),0); ?>".strtoupper($row['id']).""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

NO	REF. #	ITEM TYPE	ITEM DESCRIPTION	UoM	QUANTITYx
".strtoupper($itemClassDes)."	".strtoupper($row['header_ref_code'])."	".strtoupper($row['item_description'])."	".strtoupper($row['uom'])."	".strtoupper($row['quantity'])."

"; exit(); } ?>