format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; if(isset($_POST['done'])){ $vendorID = mysql_escape_string($_POST['vendorID']); $MyVendorCode = mysql_escape_string($_POST['EMyVendorCode']); $vendorNotes = mysql_escape_string($_POST['EvendorNotes']); $vendorName = mysql_escape_string($_POST['EvendorName']); $vendorTerm = mysql_escape_string($_POST['EvendorTerm']); $vendorTIN = mysql_escape_string($_POST['EvendorTIN']); $vendorAddress = mysql_escape_string($_POST['EvendorAddress']); $vendorFax = mysql_escape_string($_POST['EvendorFax']); $vendorLandline = mysql_escape_string($_POST['EvendorLandline']); $vendorContactPerson = mysql_escape_string($_POST['EvendorContactPerson']); $vendorMobile = mysql_escape_string($_POST['EvendorMobile']); $vendorEmail = mysql_escape_string($_POST['EvendorEmail']); mysql_query("UPDATE `prf_suppliers` SET sup_code='$MyVendorCode', sup_name='$vendorName', address='$vendorAddress', landline='$vendorLandline', vendor_fax='$vendorFax', contact_person='$vendorContactPerson', contact_person_email='$vendorEmail', contact_person_mobile='$vendorMobile', terms='$vendorTerm', tin_number='$vendorTIN', supplied_items='$vendorNotes' WHERE `id`='$vendorID' "); ?> ".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

".strtoupper($row['sup_code'])."	".strtoupper($row['sup_name'])."	".strtoupper($row['address'])."	".strtoupper($row['landline'])."	".strtoupper($row['vendor_fax'])."	".strtoupper($row['terms'])."	".strtoupper($row['contact_person'])."	".$row['contact_person_email']."	".$row['contact_person_mobile']."	".$row['tin_number']."	".strtoupper($row['supplied_items'])."
Selected Record: