\n"; $refDate = date("Ym",mktime(12, 0, 0, date("m") - 11, 1, date("Y"))); // set to true for mapping format if (array_key_exists("mapFormat", $_REQUEST)) { $q = "select * from headers where oType='FSP' and status != 'CLOSED' and status != 'VOID' order by {$_REQUEST['sortop']}"; $callList = mysql_query($q); while ($call = mysql_fetch_assoc($callList)) { echo " \n"; echo " {$call['protectron']}\n"; echo " ".fixName($call['fName'],$call['lName'])."\n"; echo " {$call['address']}, {$call['city']}\n"; echo " \n"; } } else { $q = "SELECT * FROM `headers`,`clientdat` WHERE headers.oCode=clientdat.cCode and headers.oType='FSP' and clientdat.fspDate!='' and clientdat.fspDate < '$refDate%' group by headers.oCode order by clientdat.lName"; //echo "\n"; $callList = mysql_query($q); while ($call = mysql_fetch_assoc($callList)) { //age($call['tid'], date("Ymd")); $sponsor = getClientInfo($call['oCode']); if ($call['oCode'] == $call['cCode']) { $sponsor['fName'] = ""; $sponsor['lName'] = ""; } $aAge = dateDiff($sponsor['fspDate'], date("Ymd")); //echo " \n"; echo " \n"; //echo " ".dateDiff($call['tid'], date("Ymd"))."\n"; //echo " {$call['protectron']}\n"; echo " ".fixName($call['fName'],$call['lName'])."\n"; echo " {$call['address']}\n"; echo " {$call['city']}\n"; echo " ".fixName($sponsor['fName'],$sponsor['lName'])."\n"; echo " $aAge\n"; //echo " {$call['status']}\n"; //echo " {$call['assignment']}\n"; echo " \n"; } } echo "\n"; ?>