'' 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="
|