'.$sql); if($rs=mysql_fetch_assoc($result)){ $countyName=$rs['CT_Name']; $pageName=$countyName.', '.$_VAR['STATE_NAME'].' - Surnames - '.$_VAR['PROJECT_LONG_NAME']; $headerName='Surnames for '.$countyName.''; } } DrawHeader($pageName,'','Surnames','index, follow'); ?>
Surnames - Use this page to browse the gravestone records by surname.
    Display surnames within  

";?> 0){ $sql.="CID=$cid and "; } else { $sql.="1=0 and "; } $sql.=" lcase(first)<>'cemetery' and Approved='Y' group by last order by last"; $result=mysql_query($sql) or die(mysql_error().'
'.$sql); $lastLetter=''; $openRow=false; $list=''; while($rs=mysql_fetch_assoc($result)){ $thisLetter=strtoupper(substr($rs['last'],0,1)); if($lastLetter<>$thisLetter){ if($openRow)echo "\n\n"; $lastLetter=$thisLetter; print ""; print "

".$headerName."

$thisLetter: "; $openRow=true; $firstEntry=true; } $cemURL=""; if($firstEntry){ print $cemURL; $firstEntry=false; } else { print ", $cemURL"; } $numrec++; } ?>