{"id":338,"date":"1996-01-01T10:27:31","date_gmt":"1996-01-01T10:27:31","guid":{"rendered":"http:\/\/shrule.com\/?page_id=338"},"modified":"2018-08-24T19:23:42","modified_gmt":"2018-08-24T19:23:42","slug":"ancestor-search","status":"publish","type":"page","link":"http:\/\/www.shrule.com\/?page_id=338","title":{"rendered":"Ancestor search"},"content":{"rendered":"

\"Genealogy
\nPat<\/b> for Patrick – this will get all the records entered as Pat , Patk and Patrick . If you leave this set to Any<\/i> it will include all firstnames.
..Good luck…”);<\/p>\n

\/\/cn = first name , sn = surname , cp= parish
\n\/\/##########################################################################
\nPRINTF(“<\/p>\n

“);
\nPRINTF(“<\/p>\n
“);<\/p>\n

if(isset($_REQUEST[‘submit’]))
\n { $submit = mysql_real_escape_string($_REQUEST[‘submit’]) ; }<\/p>\n

PRINTF(“<\/p>\n

\n Find your ancestors<\/legend>\n

“);
\n\/\/———————————————————————
\nPRINTF(“<\/p>\n“);
\nPRINTF(“<\/p>\n\n\n\n\n
“);
\nif(isset($_REQUEST[‘cn’]))
\n { PRINTF(““); }
\n ELSE{ PRINTF(““); }
\nPRINTF(“<\/td>\n<\/tr>\n

“);
\n\/\/———————————————————————<\/p>\n

PRINTF(“<\/p>\n

“);
\nif(isset($_REQUEST[‘sn’]))
\n { PRINTF(““); }
\n ELSE{ PRINTF(““); }
\nPRINTF(“<\/td>\n<\/tr>\n

“);
\n\/\/———————————————————————<\/p>\n

printf(“<\/p>\n

“);<\/p>\n

$query = $wpdb->prepare(
\n ‘select civilparish,cpid FROM _grp_civilparish group by cpid’ , 1 );
\n \/\/ count records in each table
\n$combo = $wpdb->get_results($query , ARRAY_N);<\/p>\n

printf(“

<\/td>\n<\/td>\n<\/tr>\n<\/table>\n<\/fieldset>\n

The following databases are searched and a link to a new page with the details will appear if results are found . . .\n<\/p><\/form>\n<\/div>\n

“);
\n\/\/#######################################################################<\/p>\n

printf(“NB :: Surnames today are often spelt differently to than they were recorded in the 18th and 19th century , for example Ryan has turned up in local records as O’Wryen , O’Royn , Roin , Ryne etc.
“);<\/p>\n

}
\nelse{
\n $query = $wpdb->prepare(
\n ‘select civilparish,cpid FROM _grp_civilparish where cpid = %s’ , $cp );
\n $row = $wpdb->get_row($query , ARRAY_A,0);
\n $civpar = $row[0];
\n PRINTF(“<\/p>\n

Search results<\/h2>\n

“);
\n if( $sn==” )
\n { PRINTF(“There are no matchs for those details , scroll down to the bottom of the page to search again .”); }
\n else{ PRINTF(“Scroll down the page to view links to more detailed results of your search for “);
\n if( $cn == ‘Any’){ PRINTF(” anyone named $sn<\/b> from”);}
\n else{ PRINTF(” $cn $sn<\/b> from”); }
\n if( $cp == ‘ALL’){ PRINTF(” any parish in the Shrule area …”); }
\n else{ PRINTF(” $civpar Civil Parish .”); }
\n }
\n }<\/p>\n

printf(“<\/p>\n

\n