'.$sql); if($rs=mysql_fetch_assoc($result)){ $countyName=$rs['CT_Name']; } $result=mysql_query($sql) or die(mysql_error().'
'.$sql); $list=''; DrawHeader($_VAR['PROJECT_LONG_NAME']." - Cemetery Index",'','Cemeteries','index, follow'); startFrame('100%'); ?>
Cemeteries - Use this page to browse the gravestone records by cemetery.
    Display cemeteries within  

'' and cemeteryID=cemID and approved='Y' and CID=$cid "; $sql.="group by CemID,CemName,CT_Name order by CemName"; $result=mysql_query($sql) or die(mysql_error().'
'.$sql); $lastLetter=''; $openRow=false; $list=''; $numrec=0; while($rs=mysql_fetch_assoc($result)){ $thisLetter=strtoupper(substr(trim($rs['CemName2']),0,1)); if($lastLetter<>$thisLetter){ if($openRow)echo "\n\n"; $lastLetter=$thisLetter; print ""; print "
$thisLetter: "; $openRow=true; $firstEntry=true; } $numrec++; $cemURL="