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'])){ $SearchCanvass = mysql_escape_string($_POST['SearchCanvass']); ?>
REC. NO REF. CODE DATE ADDED VENDOR CODE VENDOR NAME VALIDITY DATE UPLAODED BY FILE
'$myDate' AND `ref_code`='$SearchCanvass' || `deleted`= 0 AND `validity_date` > '$myDate' AND `vendor_code`='$SearchCanvass' ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdr)){ $uploadedBy=$row['uploaded_by']; $vID=$row['vendor_id']; $myVendorName = mysql_result(mysql_query("SELECT sup_name FROM prf_suppliers WHERE id='$vID'"),0); $reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$uploadedBy'"),0); $reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$uploadedBy'"),0); ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
".strtoupper($row['ref_code'])."".strtoupper($row['date_added'])."".strtoupper($row['vendor_code'])."".$myVendorName."".strtoupper($row['validity_date'])."".strtoupper($reqByLName).", ".strtoupper($reqByFName)."View
Selected Record: