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']); $chkIfVendorCodeExists=mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_suppliers` WHERE `sup_code`='$MyVendorCode'"),0); if($chkIfVendorCodeExists > 0){ //echo ""; echo ''; }else{ 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 ''; } ?> "; echo ""; echo ""; echo ""; */ $getItemHdr = mysql_query("SELECT * FROM `prf_suppliers` WHERE `deleted`=0 ORDER BY sup_name ASC"); while($row=mysql_fetch_array($getItemHdr)){ ?>".$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: