$OutStr = "";
extract($aRow);
$isFamily = false;
if ($memberCount > 1) {
$iFamilyID = $per_fam_ID;
$isFamily = true;
$pdf->sRecordName = "";
$pdf->sLastName = $fam_Name;
$OutStr .= $pdf->sGetFamilyString($aRow);
$bNoRecordName = true;
// Find the Head of Household
$sSQL = "SELECT * from (person_per {$sGroupTable}) LEFT JOIN family_fam ON per_fam_ID = fam_ID \n WHERE per_fam_ID = " . $iFamilyID . " \n AND per_fmr_ID in ({$sDirRoleHeads}) {$sWhereExt} {$sClassQualifier} {$sGroupBy}";
$rsPerson = RunQuery($sSQL);
if (mysql_num_rows($rsPerson) > 0) {
$aHead = mysql_fetch_array($rsPerson);
$OutStr .= $pdf->sGetHeadString($rsCustomFields, $aHead);
$bNoRecordName = false;
}
// Find the Spouse of Household
$sSQL = "SELECT * from (person_per {$sGroupTable}) LEFT JOIN family_fam ON per_fam_ID = fam_ID \n WHERE per_fam_ID = " . $iFamilyID . " \n AND per_fmr_ID in ({$sDirRoleSpouses}) {$sWhereExt} {$sClassQualifier} {$sGroupBy}";
$rsPerson = RunQuery($sSQL);
if (mysql_num_rows($rsPerson) > 0) {
$aSpouse = mysql_fetch_array($rsPerson);
$OutStr .= $pdf->sGetHeadString($rsCustomFields, $aSpouse);
$bNoRecordName = false;
}
// In case there was no head or spouse, just set record name to family name
if ($bNoRecordName) {
$pdf->sRecordName = $fam_Name;
}
// Find the other members of a family
$sLastLetter = "0";
while ($aRow = mysql_fetch_array($rsRecords)) {
$OutStr = "";
extract($aRow);
if ($memberCount > 1) {
$iFamilyID = $per_fam_ID;
$pdf->sRecordName = "";
$pdf->sLastName = $fam_Name;
$OutStr .= $pdf->sGetFamilyString($aRow);
$bNoRecordName = true;
// Find the Head of Household
$sSQL = "SELECT * from person_per {$sGroupTable} LEFT JOIN family_fam ON per_fam_ID = fam_ID \n\t\t\tWHERE per_fam_ID = " . $iFamilyID . " \n\t\t\tAND per_fmr_ID in ({$sDirRoleHeads}) {$sWhereExt} {$sClassQualifier} {$sGroupBy}";
$rsPerson = RunQuery($sSQL);
if (mysql_num_rows($rsPerson) > 0) {
$aHead = mysql_fetch_array($rsPerson);
$OutStr .= $pdf->sGetHeadString($aHead);
$bNoRecordName = false;
}
// Find the Spouse of Household
$sSQL = "SELECT * from person_per {$sGroupTable} LEFT JOIN family_fam ON per_fam_ID = fam_ID \n\t\t\tWHERE per_fam_ID = " . $iFamilyID . " \n\t\t\tAND per_fmr_ID in ({$sDirRoleSpouses}) {$sWhereExt} {$sClassQualifier} {$sGroupBy}";
$rsPerson = RunQuery($sSQL);
if (mysql_num_rows($rsPerson) > 0) {
$aSpouse = mysql_fetch_array($rsPerson);
$OutStr .= $pdf->sGetHeadString($aSpouse);
$bNoRecordName = false;
}
// In case there was no head or spouse, just set record name to family name
if ($bNoRecordName) {
$pdf->sRecordName = $fam_Name;
}
// Find the other members of a family
