format("Y-m-d"); //if submit/ save to databasevar if(isset($_POST['done'])){ $dealCode = mysql_escape_string($_POST['dealCode']); $dealName = mysql_escape_string($_POST['dealName']); $address = mysql_escape_string($_POST['address']); $location = mysql_escape_string($_POST['location']); $company = mysql_escape_string($_POST['company']); $contact = mysql_escape_string($_POST['contact']); $addBy = mysql_escape_string($_POST['addBy']); $addDate = mysql_escape_string($_POST['addDate']); $outStat = 1; $outCode = 'OUT'; //insert mysql_query("INSERT INTO vts_dealerships (deal_code, deal_name, deal_address, deal_city, deal_contact, comp_id, date, add_by) VALUES('{$dealCode}','{$dealName}','{$address}','{$location}','{$contact}','{$company}','{$addDate}','{$addBy}')"); //UPDATE CHECK-OUT REASON TABLE TO INCLUDE DEALER IN SELECTION DURING GUARD CHECK-OUT mysql_query("INSERT INTO vts_check_out_reasons (out_description, out_status, code) VALUES('{$dealName}','{$outStat}','{$outCode}')"); $systemMessage="Record has been saved..."; exit(); } //display from database if(isset($_POST['display'])){ $result = mysql_query("SELECT * FROM vts_dealerships WHERE `deal_status`=1 ORDER BY `date` DESC"); echo ""; echo ""; while($row=mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

CODE	COMPANY	DEALERSHIP	ADDRESS	CITY	STATUS
".$row['deal_code']."	"; $compCode = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='".$row['comp_id']."'"),0); echo $compCode; echo "	".$row['deal_name']."	".$row['deal_address']."	".$row['deal_city']."	"; if($row['deal_status']==1){echo 'Active';}else{echo 'InActive';} echo"

"; exit(); } ?>