format("Y-m-d"); if(isset($_POST['trans'])){ $ItemRecordIDLoad = mysql_escape_string($_POST['ItemRecordIDLoad']); $UpdateuReferenceID = mysql_escape_string($_POST['UpdateuReferenceID']); //echo $UpdateuReferenceID; ?> '$prfDate'"); $getActiveProposals = mysql_query("SELECT * FROM `prf_uploadedcanvass` WHERE `deleted`=0 AND `validity_date` > '$prfDate' AND `notes` LIKE '%$UpdateuReferenceID%'"); while($cRow = mysql_fetch_array($getActiveProposals)){ $cvID = $cRow['id']; $checkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_canvass_sheet WHERE `canvass_id`='$cvID' AND `item_id`='$ItemRecordIDLoad'"),0); if($checkIfExist==0){ $cvFileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); ?>".$cRow['date_added'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } ?>

".$cRow['ref_code']."

".$cRow['vendor_code']."

"; $uploadVCode = $cRow['vendor_code']; $supName = mysql_result(mysql_query("SELECT sup_name FROM prf_suppliers WHERE sup_code='$uploadVCode'"),0); echo strtoupper($supName); echo "

".$cRow['validity_date']."

"; $uploadID = $cRow['uploaded_by']; $upFname = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$uploadID'"),0); $upLname = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$uploadID'"),0); echo strtoupper($upLname). ", ".strtoupper($upFname); echo "

📑