{"id":944,"date":"1999-01-01T18:08:11","date_gmt":"1999-01-01T18:08:11","guid":{"rendered":"http:\/\/shrule.com\/?page_id=944"},"modified":"2018-10-05T12:32:18","modified_gmt":"2018-10-05T12:32:18","slug":"ancestor-search-flax-growers-1796","status":"publish","type":"page","link":"http:\/\/www.shrule.com\/?page_id=944","title":{"rendered":"Ancestor search :: Flax Growers 1796"},"content":{"rendered":"<p><img decoding=\"async\" src=\"http:\/\/www.shrule.com\/wp-content\/uploads\/2012\/02\/genealogy.png\" alt=\"Genealogy :: the  search for you ancestors\" title=\"Genealogy :: the  search for you ancestors\" width=\"600\" align=\"center\" \/><\/p>\n<p><h2>Spinning wheel or Flax growers (1796)<\/h2>\n<p><?php\nglobal $wpdb;\n\/\/------------------------------------------------------------\n$pid  =  $_REQUEST['page_id'];  \/\/ current page id in wordpress\n\nif(isset($_REQUEST['submit'])) {  $submit   = $_REQUEST['submit'] ; }\nif(isset($_REQUEST['cn'])) {  $cn= $_REQUEST['cn'] ; }\nif(isset($_REQUEST['sn'])) {  $sn= $_REQUEST['sn'] ;  }\nif(isset($_REQUEST['cp'])) {  $cp= $_REQUEST['cp'] ;  }\n\nswitch($cn)\n   {  case ''    :  $f_cn = '%' ;      break;\n      case '*'   :  $f_cn = '%' ;      break;\n      case 'Any' :  $f_cn = '%' ;      break;\n      default    :  $f_cn = $cn ;\n    }\nif( $f_cn == '%' )\n   { $cn = 'Any' ; }  \/\/ firstname\n\nswitch($sn)\n   {  case ''  :  $f_sn = 'xxxxxxxx' ;      break;\n      case '*' :  $f_sn = 'xxxxxxxx' ;       break;\n      case '%' :  $f_sn = 'xxxxxxxx' ;      break;\n      default  :  $f_sn = $sn ;           \n\t}\nif( $f_sn == 'xxxxxxxx' ){ $sn = '' ; }  \/\/ surname\n\nswitch($cp)\n   {  case ''  :  $f_cp = 'ALL' ;   break;\n      case '*' :  $f_cp = 'ALL' ;   break;\n      case '%' :  $f_cp = 'ALL' ;   break;\n      default  :  $f_cp = $cp ;  \n    }\nif( $f_pn ==  'ALL' )\n   { $pn = 'ALL' ; }  \/\/ parish\n\n\nif( $submit == \"Search\")\n  {\n   \/\/----------- search 1796 flax ---------------------------\n    if($cp == 'ALL')\n        {  $query = $wpdb->prepare(&#8216; select * from _gr_flax1796<br \/>\n                 WHERE soundex(surname) like soundex(%s)&#8217;,$f_sn) ;<br \/>\n\t\t }<br \/>\n       else<br \/>\n          { $query = $wpdb->prepare(&#8216; select * from _gr_flax1796<br \/>\n                 WHERE soundex(surname) like soundex(%s)<br \/>\n                       AND RIGHT(cpid,3) LIKE %s&#8217;,$f_sn ,$f_cp) ;<br \/>\n\t\t   }<\/p>\n<p>     $res = $wpdb->get_results($query , ARRAY_N);<\/p>\n<p>    if($res) \/\/ is there a good result<br \/>\n  \t {  $norows = $wpdb->num_rows ;<br \/>\n  \t    if( $norows > 0 )<br \/>\n           {<br \/>\n\t\t     printf(&#8221; There are %s entries in the Flax Growers list.&#8221;, $norows);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n             printf(&#8220;<\/p>\n<ul> &#8220;);<br \/>\n             foreach ( $res as $row )<br \/>\n                  {<br \/>\n                   printf(&#8220;<\/p>\n<li>$row[3] $row[4]  from  $row[2] <\/li>\n<p> &#8220;);<br \/>\n\t\t\t\t   }<br \/>\n             printf(&#8220;<\/ul>\n<p>&#8220;);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n            }<br \/>\n          else<br \/>\n            {<br \/>\n            Printf(&#8220;Sorry no entries match your query in the Flax Growers list.<br \/>&#8220;);<br \/>\n            }<br \/>\n      }   \/\/&#8212;&#8212;&#8212;&#8211; search end   &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n   }<\/p>\n<p>\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>printf(&#8220;<\/li>\n<p>End of records for this search<br \/>\n<br \/>Search the Flax growers (1796) list for other people &#8230;.<\/p>\n<hr \/>\n<li>&#8220;);\n<p>PRINTF(&#8220;<\/p>\n<div class=\\\"formshrule\\\">&#8220;);<br \/>\nPRINTF(&#8220;<\/p>\n<form METHOD=\\\"POST\\\" ACTION=\\\"?page_id=$pid\\\">&#8220;);<\/p>\n<p>if(isset($_REQUEST[&#8216;submit&#8217;]))<br \/>\n    {    $submit   = $_REQUEST[&#8216;submit&#8217;] ;  }<\/p>\n<p>PRINTF(&#8220;<\/p>\n<fieldset>\n<legend>Search the Flax growers (1796) records<\/legend>\n<p>&#8220;);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nPRINTF(&#8220;<\/p>\n<table>&#8220;);<br \/>\nPRINTF(&#8220;<\/p>\n<tr>\n<td><label for=\\\"firstname\\\">First name ::<\/label><\/td>\n<td>&#8220;);<\/p>\n<p>if(isset($_REQUEST[&#8216;cn&#8217;]))<br \/>\n      {    PRINTF(&#8220;<input TYPE=\\\"TEXT\\\" NAME=\\\"cn\\\" VALUE=\\\"$cn\\\" \/>&#8220;);<br \/>\n\t    }<br \/>\n  ELSE{    PRINTF(&#8220;<input TYPE=\\\"TEXT\\\" NAME=\\\"cn\\\" VALUE=\\\"Any\\\" \/>&#8220;);<br \/>\n     \t}<\/p>\n<p>PRINTF(&#8220;<\/td>\n<\/tr>\n<p>&#8220;);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>PRINTF(&#8220;<\/p>\n<tr>\n<td><label for=\\\"surname\\\">Surname or last name ::<\/label><\/td>\n<td>&#8220;);<br \/>\nif(isset($_REQUEST[&#8216;sn&#8217;]))<br \/>\n   {  $cn= $_REQUEST[&#8216;sn&#8217;] ;<br \/>\n      PRINTF(&#8220;<input TYPE=\\\"TEXT\\\" NAME=\\\"sn\\\" VALUE=\\\"$sn\\\" \/>&#8220;);    }<br \/>\n   ELSE{ PRINTF(&#8220;<input TYPE=\\\"TEXT\\\" NAME=\\\"sn\\\" \/>&#8220;);            }<br \/>\nPRINTF(&#8220;<\/td>\n<\/tr>\n<p>&#8220;);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>printf(&#8220;<\/p>\n<tr>\n<td><label for=\\\"parish\\\">Select the Parish ::<\/label><\/td>\n<td>&#8220;);<\/p>\n<p>$query = $wpdb->prepare(&#8216;select civilparish,cpid FROM _grp_civilparish group by cpid&#8217;,1);<br \/>\n \/\/ count records in each table<br \/>\n$combo = $wpdb->get_results($query , ARRAY_N);<br \/>\nprintf(&#8220;<select NAME=\\\"cp\\\" CLASS=\\\"input_field\\\" \/>&#8220;);<br \/>\nif(isset($_REQUEST[&#8216;cp&#8217;]))<br \/>\n         {    $cp= $_REQUEST[&#8216;cp&#8217;] ;<br \/>\n               if($cp <> &#8216;ALL&#8217;){ printf(&#8220;<option VALUE=\\\"ALL\\\">All parishes<\/option>&#8220;); }<br \/>\n                 else{ printf(&#8220;<option VALUE=\\\"ALL\\\" SELECTED>All parishes<\/option>&#8220;); }          }<br \/>\n    else{printf(&#8220;<option VALUE=\\\"ALL\\\" SELECTED>All parishes<\/option>&#8220;);}<\/p>\n<p>foreach ( $combo as $row )<br \/>\n\t     {  $cp_code = substr($row[1],0,6) ;<br \/>\n                 if($cp == $cp_code)<br \/>\n                     {        PRINTF(&#8220;<option VALUE=\\\"$cp_code\\\" SELECTED>$row[0]<\/option>&#8220;);    }<br \/>\n                    else{ PRINTF(&#8221;<option VALUE=\\\"$cp_code\\\">$row[0]<\/option>&#8220;);   }                      }<br \/>\nprintf(&#8220;<\/select><\/td>\n<\/tr>\n<p>&#8220;);<br \/>\n\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n\/\/mysql_free_result($combo);<\/p>\n<p>?><\/p>\n<tr>\n<td><input type=\"reset\" VALUE=\"Clear form\"\/><\/td>\n<td><input TYPE=\"submit\" NAME=\"submit\" VALUE=\"Search\"><\/td>\n<\/tr>\n<\/table>\n<\/fieldset>\n<\/form>\n<\/div>\n<\/li>\n<\/ul>\n<p><\/p>\n<h2>Spinning wheel or Flax growers (1796)<\/h2>\n<p>As part of a government scheme to encourage the linen trade, free spinning wheels or looms were granted to individuals planting a certain area of land with flax.<br \/>\nThe lists of those entitled to the awards, covering almost 60,000 individuals, were published in 1796, and record only the names of the individuals and the civil parish in which they lived. The majority were in Ulster, but some names appear from every county except Dublin and Wicklow. A microfiche index to the lists is available in the National Archives.The records only record the name of the grantee and the civil parish in which he lived making it difficult to confirm the relevance of any particular entry. However the Lists are still a very useful source if for no other purpose than to confirm the presence of a particular name in an area at that time.<br \/>\nA list of flax growers for the area is available here thanks to Robert Dooley ( rdooley @ twcny.rr.com )who has been doing genealogy research on his family in the Mirehill, Co. Galway area\n <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Spinning wheel or Flax growers (1796) Spinning wheel or Flax growers (1796) As part of a government scheme to encourage the linen trade, free spinning wheels or looms were granted to individuals planting a certain area of land with flax. The lists of those entitled to the awards, covering almost 60,000 individuals, were published in [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":0,"parent":338,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-944","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages\/944","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"http:\/\/www.shrule.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=944"}],"version-history":[{"count":0,"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages\/944\/revisions"}],"up":[{"embeddable":true,"href":"http:\/\/www.shrule.com\/index.php?rest_route=\/wp\/v2\/pages\/338"}],"wp:attachment":[{"href":"http:\/\/www.shrule.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}