format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; if(isset($_POST['done'])){ $MyVendorCode = mysql_escape_string($_POST['MyVendorCode']); $vendorNotes = mysql_escape_string($_POST['vendorNotes']); $vendorName = mysql_escape_string($_POST['vendorName']); $vendorTerm = mysql_escape_string($_POST['vendorTerm']); $vendorTIN = mysql_escape_string($_POST['vendorTIN']); $vendorAddress = mysql_escape_string($_POST['vendorAddress']); $vendorFax = mysql_escape_string($_POST['vendorFax']); $vendorLandline = mysql_escape_string($_POST['vendorLandline']); $vendorContactPerson = mysql_escape_string($_POST['vendorContactPerson']); $vendorMobile = mysql_escape_string($_POST['vendorMobile']); $vendorEmail = mysql_escape_string($_POST['vendorEmail']); mysql_query("INSERT INTO `prf_suppliers`(sup_code,sup_name,address,landline,vendor_fax,contact_person,contact_person_email,contact_person_mobile,terms,tin_number,supplied_items,date_added) VALUES('{$MyVendorCode}','{$vendorName}','{$vendorAddress}','{$vendorLandline}','{$vendorFax}','{$vendorContactPerson}','{$vendorEmail}','{$vendorMobile}','{$vendorTerm}','{$vendorTIN}','{$vendorNotes}','{$myDate}')"); // echo "Alert('This is a test');"; ?> "; echo ""; echo ""; echo ""; $getItemHdr = mysql_query("SELECT * FROM `prf_suppliers` WHERE `deleted`=0 ORDER BY sup_name ASC LIMIT $offSet, $noOfRecordPerPage "); while($row=mysql_fetch_array($getItemHdr)){ ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

".strtoupper($row['sup_code'])."	".strtoupper($row['sup_name'])."	".strtoupper($row['terms'])."	".strtoupper($row['contact_person'])."	".$row['contact_person_email']."	".$row['contact_person_mobile']."
Selected Record: