'.$sql); if($rs=mysql_fetch_assoc($result)){ $countyName=$rs['CT_Name']; } } DrawHeader($_VAR['PROJECT_LONG_NAME']." - Surname Index",'','Surnames'); ?>
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 "
$thisLetter: "; $openRow=true; $firstEntry=true; } $cemURL=""; if($firstEntry){ print $cemURL; $firstEntry=false; } else { print ", $cemURL"; } $numrec++; } ?>