"#") { $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']; } } $result=mysql_query($sql) or die(mysql_error().'
'.$sql); $list=''; DrawHeader($_VAR['PROJECT_LONG_NAME']." - Province/State Index",'','','index, follow'); startFrame('100%'); ?>
Province/State - Use this page to browse the photos by province/state.
    Display provinces/states within  

'' and cemeteryID=cemID and approved='Y' "; if ($cid<>"#") $sql.=" 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=Mb::strtoupper(Mb::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=" $cemURL"; } } ?>