![\"Genealogy](\"http:\/\/www.shrule.com\/wp-content\/uploads\/2012\/02\/genealogy.png\" "\\"Genealogy")
<\/p>\n<\/p>\n
Head of Household forms :: showing building and property details .<\/p>\n
prepare(‘ select * from _gr_census_1901hoh
\n left join _grp_townlands
\n on _gr_census_1901hoh.TL_ID = _grp_townlands.TLid
\n WHERE SOUNDEX(hoh_surname) like SOUNDEX(%s)
\n OR landlord like %s’,$f_sn , $seek) ;
\n }
\n else
\n { $seek = ‘%$f_sn’ ;
\n $query = $wpdb->prepare(‘ select * from _gr_census_1901hoh
\n left join _grp_townlands
\n on _gr_census_1901hoh.TL_ID = _grp_townlands.TLid
\n WHERE ( _gr_census_1901hoh .status = RIGHT(%s,3) )
\n AND ( ( SOUNDEX(hoh_surname) = SOUNDEX(%s))
\n OR( landlord like %s ) )’,$f_cp ,$f_sn ,$seek ) ;
\n }<\/p>\n
$res = $wpdb->get_results($query , ARRAY_N);<\/p>\n
if($res ) \/\/ is there a good result
\n \t{ $norows = $wpdb->num_rows ;
\n \t if( $norows > 0 )
\n {
\n printf(” There are %s entries closely matching your search in the Census 1901 Head of Household list.<\/p>\n
“, $norows);
\n \/\/——————————————————–
\n printf(“<\/p>\n
“);
\n } \/\/##################################
\n printf(“<\/ul>\n
“);
\n\/\/—————————————————–
\n }
\n else
\n {
\n Printf(“Sorry no entries match your query in the Census 1901 Head of Households list.<\/p>\n
“);
\n }
\n }
\n\/\/———–1901 b1 hoh search end —————————<\/p>\n
\/\/######################################################################
\nprintf(“<\/p>\n
“);
\nprintf(“Family forms , detailing each person present on census night .
“);
\n\/\/ 1901 a form goes here when done<\/p>\n
$query = $wpdb->prepare( ‘ select * from _gr_census_1901a
\n left join _grp_townlands
\n on _gr_census_1901a.TownlandID = _grp_townlands.TLid
\n WHERE SOUNDEX(surname) like SOUNDEX(%s) ‘,$f_sn ) ;<\/p>\n
$res = $wpdb->get_results($query , ARRAY_N);<\/p>\n
if($res ) \/\/ is there a good result
\n { $norows = $wpdb->num_rows ;
\n if( $norows > 0 )
\n {
\n printf(” There are %s entries closely matching your search in the Census 1901 Family Form list.”, $norows);\/\/——————————————————–
\n printf(“<\/p>\n
“);
\n } \/\/##################################
\n printf(“<\/ul>\n
“);
\n\/\/—————————————————–
\n }
\n else
\n {
\n Printf(“Sorry no entries match your query in the Census 1901 census from this area.
“);
\n }
\n }
\n\/\/———–1901 b1 search end —————————<\/p>\n
\/\/############################################<\/p>\n
\/\/ end of the submit check xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx<\/p>\n
printf(“<\/p>\n
“);
\nprintf(“Search the records for other people ..”);<\/p>\n
}<\/p>\n
printf(“<\/li>\n
PRINTF(“<\/p>\n