Surname Registry – R

Surnames are listed in alphabetical order. Click on the first letter of the name you are researching.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

select_db($database) or die( “Unable to select database”);

$alpha = “surname LIKE ‘r%'”; ///////////////// CHANGE THIS TO MATCH LETTER OF PAGE

$query=”SELECT * FROM ccgs.surreg WHERE $alpha ORDER BY surname, givenname ASC”;

$result=mysqli_query($mysqli,$query);
$rows=mysqli_num_rows($result);
$i=0;
while ($i < $rows) { $sgiven=""; $sbyear=""; $sdyear=""; mysqli_data_seek($result, $i); $sur=mysqli_fetch_array($result)["surname"]; mysqli_data_seek($result, $i); $given=mysqli_fetch_array($result)["givenname"]; mysqli_data_seek($result, $i); $byear=mysqli_fetch_array($result)["birthyear"]; mysqli_data_seek($result, $i); $dyear=mysqli_fetch_array($result)["deathyear"]; mysqli_data_seek($result, $i); $loc=mysqli_fetch_array($result)["location"]; mysqli_data_seek($result, $i); $sub=mysqli_fetch_array($result)["submitter"]; mysqli_data_seek($result, $i); $semail=mysqli_fetch_array($result)["email"]; mysqli_data_seek($result, $i); $when=mysqli_fetch_array($result)["subwhen"]; mysqli_data_seek($result, $i); $info=mysqli_fetch_array($result)["moreinfo"]; if (!empty($given)) {$sgiven = "$given,";} if (!empty($byear)) {$sbyear = "b. $byear,";} if (!empty($dyear)) {$sdyear = "d. $dyear,";} $sur = strtoupper($sur); echo "

$sur – $sgiven $sbyear $sdyear $loc
Submitted by $sub $when“;
if (!empty($info))
{
echo “

$info

“;
}
echo “

“;
$i++;
}
?>