include "_header.php";
$pageName=$_VAR['PROJECT_LONG_NAME']." - Surname Index";
$headerName='';
if(empty($cid)){
$cid=-1;
} else {
$sql="select CT_Name from countylist where CountyID=$cid";
$result=mysql_query($sql) or die(mysql_error().'
'.$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');
?>
".$headerName." | ";?>
$numrec=0;
$sql="select last,count(entryid) as qty from gravestone where ";
if($cid>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().'|
$thisLetter: | "; print ""; $openRow=true; $firstEntry=true; } $cemURL="".str_replace(' ',' ',$rs['last']).""; if($firstEntry){ print $cemURL; $firstEntry=false; } else { print ", $cemURL"; } $numrec++; } ?> |