<?php
error_reporting(E_ALL);
$userIDKey=$userListRow['id'];
include 'include/userConnect.php';
$beginDate=mysql_real_escape_string($_POST['begin']);
$endDate=mysql_real_escape_string($_POST['end']);
$auditTypeKey=mysql_real_escape_string($_POST['type']);
$branchKey=mysql_real_escape_string($_POST['branch']);
$d = "DROP Table if exists auditMgmt";
mysql_query($d) or die(mysql_error());
$c = "CREATE TABLE auditMgmt SELECT loan.loanKey,
loan.loanNumber,
borrower.lastName,
borrower.firstName,
audit.auditID,
loan.branchKey,
audit.trackingDate
FROM loan
JOIN audit USING (loanKey)
LEFT JOIN borrower USING (loanKey)
WHERE loan.branchKey='$branchKey'
AND audit.activeStatus='1'
AND auditTypeKey='$auditTypeKey'
AND borrower.type='1'
AND borrower.active='1'
AND trackingDate BETWEEN '$beginDate' AND '$endDate'
ORDER BY audit.auditID";
mysql_query($c) or die(mysql_error());
?>
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.