Thanks, that tightened it up significantly. Current code to build where clause (and yes, I did mean to change it to AND):
// build where clause
if (empty($_POST['form1'])) {
$sWhere = '';
}
if($sWhere == 'WHERE ') {
$sWhere .= ' AND eosdetail.SDserviceDate BETWEEN "' . $_POST['start_date'] . '" AND "' . $_POST['end_date'] . '"';
} else {
$sWhere = 'WHERE ' . implode(' AND ', $aWhere);
}
Here are some of the things happening now:
Name and dates field entered:
SELECT claimrecord.CRclaimNumber, patient.PTssn, patient.PTnameFirst, patient.PTnameLast, eosdetail.SDserviceDate FROM claimrecord, patient, eosdetail WHERE patient.PTnameLast = "doe" AND patient.PTnameFirst = "john" AND eosdetail.SDserviceDate BETWEEN "aaa" AND "aaa"
Dates only:
SELECT claimrecord.CRclaimNumber, patient.PTssn, patient.PTnameFirst, patient.PTnameLast, eosdetail.SDserviceDate FROM claimrecord, patient, eosdetail WHERE eosdetail.SDserviceDate BETWEEN "aaa" AND "aaa"
SSN and claim:
SELECT claimrecord.CRclaimNumber, patient.PTssn, patient.PTnameFirst, patient.PTnameLast, eosdetail.SDserviceDate FROM claimrecord, patient, eosdetail WHERE claimrecord.CRclaimNumber = "11111111" AND patient.PTssn = "123456789"
EDIT: the only issue now seems to be that the WHERE is still tacked on when submitting an empty form.
SELECT claimrecord.CRclaimNumber, patient.PTssn, patient.PTnameFirst, patient.PTnameLast, eosdetail.SDserviceDate FROM claimrecord, patient, eosdetail WHERE
