= CURDATE()"; $sql_ext .= " ORDER BY events.`Date` ASC"; $searchmode = array(); $stdsearchopt = array(); $searchmode[0] = 1; $searchmode[1] = 0; $searchmode[2] = 0; $stdsearchopt[0]=0; $stdsearchopt[1]=0; $stdsearchopt[2]=0; if(!$result = @mysql_query($sql . " " . $sql_ext . " limit 0,1")){ $err_string .= "Error:while connecting to database
" . mysql_error(); } if ($err_string != "") { print "
"; print ""; print ""; print ""; print "
"; print ""; print $err_string; print ""; print "
"; exit; } $filter_string = ""; $qry_string = ""; $i = 0; $searchendkey =""; $searchstartkey = ""; while ($i < mysql_num_fields($result)) { $meta = mysql_fetch_field($result); $field_name = $meta->name; $field_table = $meta->table; $field_type = $meta->type; if (($searchmode[$i])==0) { # 0 = Std, 1 = Advance if (($stdsearchopt[$i])==0) { # 0=Contain , 1 = Equal : for standard mode $searchstartkey = "%"; $searchendkey = "%"; }else { $searchstartkey = ""; $searchendkey = ""; } } else { $searchstartkey= ""; $searchendkey = ""; } if ((qsrequest("search_fd" . $i) != "") && (qsrequest("search_fd" . $i) != "*")) { $idata = qsrequest("search_fd" . $i); $idata = str_replace("*", "%", $idata); $irealdata = $idata; $iopt = substr($idata, 0, 2); if (($iopt == "<=") || ($iopt == "=<")) { $iopt = "<="; $irealdata = substr($idata, 2); } elseif (($iopt == ">=") || ($iopt == "=>")) { $iopt = ">="; $irealdata = substr($idata, 2); } elseif ($iopt == "==") { $iopt = "="; $irealdata = substr($idata, 2); } elseif ($iopt == "<>") { $irealdata = substr($idata, 2); } else { $iopt = substr($idata, 0, 1); if (($iopt == "<") || ($iopt == ">") || ($iopt == "=")) { $irealdata = substr($idata,1); } else { $iopt = "="; } } if (!strcasecmp($idata,"{current date and time}")) { $idata = time(); } elseif (!strcasecmp($idata,"{current date}")) { $idata = time(); } elseif (!strcasecmp($idata,"{current time}")) { $idata = time(); } if ($meta) { if ((strtolower($field_type) == "timestamp") ||(strtolower($field_type) == "datetime") ||(strtolower($field_type) == "smalldatetime") ||(strtolower($field_type) == "date") ||(strtolower($field_type) == "time") ||(strtolower($field_type) == "year")) { if ((($timestamp = strtotime($irealdata)) !== -1)) { if (($iopt)=="="){ $conditionstr = " = "; $istrdata = str_replace("=", "", $istrdata); } else { $conditionstr = $iopt; $istrdata = $irealdata; $searchstartkey = ""; $searchendkey = ""; } if ((qsrequest("multisearch_fd" . $i) != "")) { $multisearch = qsrequest("multisearch_fd" . $i); $searcharray = split(",",$multisearch); if ($qry_string == "") { $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata)); $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i); $filter_string = "(" . $fields[$i] . $conditionstr . " ". $quotedate . $searchstartkey . $irealdata . $searchendkey . $quotedate; $j = 0; for ($j = 0; $j < count($searcharray); $j++) { $searchindex = $searcharray[$j]; $filter_string .= " OR " . $fields[$searchindex] . $conditionstr . " ". $quotedate . $searchstartkey . $irealdata . $searchendkey . $quotedate; } $filter_string .= ")"; } else { $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata)); $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i); $filter_string .= " AND (" . $fields[$i] . $conditionstr . " " . $quotedate . $searchstartkey . $irealdata . $searchendkey . $quotedate; $j = 0; for ($j = 0; $j < count($searcharray); $j++) { $searchindex = $searcharray[$j]; $filter_string .= " OR " . $fields[$searchindex] . $conditionstr . " " . $quotedate . $searchstartkey . $irealdata . $searchendkey . $quotedate; } $filter_string .= ")"; } } else { if ($qry_string == "") { $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata)); $filter_string = $fields[$i] . $conditionstr . " " . $quotedate . $searchstartkey . $irealdata . $searchendkey . $quotedate; } else { $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata)); $filter_string .= " AND " . $fields[$i] . $conditionstr . " " . $quotedate . $searchstartkey . $irealdata . $searchendkey . $quotedate; } } } else { $err_string .= "Error:while searching." . $field_name . ".
"; $err_string .= "Description: Invalid DateTime.
"; } } elseif (($meta->numeric) == 1) { $irealdata = str_replace("%", "", $irealdata); if (is_numeric($irealdata)) { if ((qsrequest("multisearch_fd" . $i) != "")) { $multisearch = qsrequest("multisearch_fd" . $i); $searcharray = split(",",$multisearch); if ($qry_string == "") { $qry_string = "search_fd" . $i . "=" . $idata; $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i); $filter_string = "(" . $fields[$i] . " " . $iopt . " " . $irealdata; $j = 0; for ($j = 0; $j < count($searcharray); $j++) { $searchindex = $searcharray[$j]; $filter_string .= " OR " . $fields[$searchindex] . " " . $iopt . " " . $irealdata; } $filter_string .= ")"; } else { $qry_string .= "&search_fd" . $i . "=" . $idata; $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i); $filter_string .= " AND (" . $fields[$i] . " " . $iopt . " " . $irealdata; $j = 0; for ($j = 0; $j < count($searcharray); $j++) { $searchindex = $searcharray[$j]; $filter_string .= " OR " . $fields[$searchindex] . " " . $iopt . " " . $irealdata; } $filter_string .= ")"; } } else { if ($qry_string == "") { $qry_string = "search_fd" . $i . "=" . $idata; $filter_string = $fields[$i] . " " . $iopt . " " . $irealdata; } else { $qry_string .= "&search_fd" . $i . "=" . $idata; $filter_string .= " AND " . $fields[$i] . " " . $iopt . " " . $irealdata; } } } else { $err_string .= "Error:while searching." . $field_name . ".
"; $err_string .= "Description: Type mismatch.
"; } } elseif ((strtolower($field_type) == "blob") ||(strtolower($field_type) == "mediumblob") ||(strtolower($field_type) == "longblob")) { if ($qry_string == "") { $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata)); $filter_string = $fields[$i] . " Like '" . ereg_replace("'","''",stripslashes($irealdata)) . "'"; } else { $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata)); $filter_string .= " AND " . $fields[$i] . " Like '" . ereg_replace("'","''",stripslashes($irealdata)) . "'"; } } elseif ((strtolower($field_type) == "varchar") ||(strtolower($field_type) == "char") ||(strtolower($field_type) == "text") ||(strtolower($field_type) == "tinytext") ||(strtolower($field_type) == "mediumtext") ||(strtolower($field_type) == "string") ||(strtolower($field_type) == "longtext") ||(strtolower($field_type) == "nvarchar") ||(strtolower($field_type) == "nchar") ||(strtolower($field_type) == "ntext")) { if (($iopt)=="="){ $conditionstr = " Like "; $istrdata = str_replace("=", "", $istrdata); } else { $conditionstr = $iopt; $istrdata = $irealdata; $searchstartkey = ""; $searchendkey = ""; } if ((qsrequest("multisearch_fd" . $i) != "")) { $multisearch = qsrequest("multisearch_fd" . $i); $searcharray = split(",",$multisearch); if ($qry_string == "") { $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata)); $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i); $filter_string = "(" . $fields[$i] . $conditionstr . " '" .$searchstartkey. ereg_replace("'","''",stripslashes($irealdata)). $searchendkey . "'"; $j = 0; for ($j = 0; $j < count($searcharray); $j++) { $searchindex = $searcharray[$j]; $filter_string .= " OR " . $fields[$searchindex] . $conditionstr . " '" .$searchstartkey. ereg_replace("'","''",stripslashes($irealdata)). $searchendkey . "'"; } $filter_string .= ")"; } else { $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata)); $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i); $filter_string .= " AND (" . $fields[$i] . $conditionstr . " '" .$searchstartkey. ereg_replace("'","''",stripslashes($irealdata)) . $searchendkey . "'"; $j = 0; for ($j = 0; $j < count($searcharray); $j++) { $searchindex = $searcharray[$j]; $filter_string .= " OR " . $fields[$searchindex] . $conditionstr . " '" .$searchstartkey. ereg_replace("'","''",stripslashes($irealdata)) . $searchendkey . "'"; } $filter_string .= ")"; } } else { if ($qry_string == "") { $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata)); $filter_string = $fields[$i] . $conditionstr . " '" .$searchstartkey. ereg_replace("'","''",stripslashes($irealdata)) . $searchendkey . "'"; } else { $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata)); $filter_string .= " AND " . $fields[$i] . $conditionstr . " '" .$searchstartkey. ereg_replace("'","''",stripslashes($irealdata)) . $searchendkey . "'"; } } } else { if ((qsrequest("multisearch_fd" . $i) != "")) { $multisearch = qsrequest("multisearch_fd" . $i); $searcharray = split(",",$multisearch); $irealdata = str_replace("%", "", $irealdata); if ($qry_string == "") { $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata)); $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i); $filter_string = "(" . $fields[$i] . " = '" . ereg_replace("'","''",stripslashes($irealdata)) . "'"; $j = 0; for ($j = 0; $j < count($searcharray); $j++) { $searchindex = $searcharray[$j]; $filter_string .= " OR " . $fields[$searchindex] . " = '" . ereg_replace("'","''",stripslashes($irealdata)) . "'"; } $filter_string .= ")"; } else { $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata)); $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i); $filter_string .= " AND (" . $fields[$i] . " = '" . ereg_replace("'","''",stripslashes($irealdata)) . "'"; $j = 0; for ($j = 0; $j < count($searcharray); $j++) { $searchindex = $searcharray[$j]; $filter_string .= " OR " . $fields[$searchindex] . " = '" . ereg_replace("'","''",stripslashes($irealdata)) . "'"; } $filter_string .= ")"; } } else { if ($qry_string == "") { $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata)); $filter_string = $fields[$i] . " like '" . ereg_replace("'","''",stripslashes($irealdata)) . "'"; } else { $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata)); $filter_string .= " AND " . $fields[$i] . " like '" . ereg_replace("'","''",stripslashes($irealdata)) . "'"; } } } } } $i++; } if ($result > 0) {mysql_free_result($result);} if ($filter_string != "") { $sql .= " and " . $filter_string; } if (qsrequest("sortfield") != "") { $sql = $sql . " Order By " . stripslashes(qsrequest("sortfield")) . " " . stripslashes(qsrequest("sortby")); $sortstring = "&sortfield=" . qsrequest("sortfield") . "&sortby=" . qsrequest("sortby"); } else { $sql = $sql . " " . $sql_ext; } $result = mysql_query($sql) or die("Invalid query"); $num_rows = mysql_num_rows($result); if (isset($_GET["page"])) { $current_page = $_GET["page"]; } elseif (isset($_POST["page"])) { $current_page = $_POST["page"]; } else { $current_page = 1; } $page_size = 25; $page_count = ceil($num_rows/$page_size); if ($current_page > $page_count) { $current_page = $page_count; } if ($current_page < 1) { $current_page = 1; } if ($page_count < 1) { $page_count = 1; } ?> Genealogy Fulton County Pennsylvania History Cemetery List

about our library

The Historical Society's library collection is housed in the George Ritzert Room at the Fulton County Library, 227 North First Street, McConnellsburg, PA. It is open Monday through Saturday during regular library hours to members and the public at no charge after they register with photo ID.

Included in the collection are:

  • Family history folders with photocopies of genealogical papers
  • A cemetery file of tombstone names and dates throughout the county
  • Some school and church records
  • Census and reference books including the full set of Pennsylvania Archives
  • 300 microfilm reels of courthouse documents and local newspapers including the Fulton County News 1899-2000, the Fulton Democrat 1889-1975, and the Fulton Republican 1865-1921; all newspaper microfilms have some years missing.
  • Church records
  • Photographs
  • Microfilmed census
  • Wills and deeds

Library donations on Fulton County families will be gladly added to the collection.

microfilm reader

The long-awaited day arrived December 11, 2003, when the Fulton County Library received its new microfilm scanner. Funding for the purchase came from a federal Library Services and Technology Act (LSTA) grant administered by the Office of Commonwealth Libraries. In addition to reading reels of microfilm, the machine, a Canon MS-350, can scan newspaper articles, obituaries, wills, deeds, etc. to computer where the data can be saved to floppy disk for printing or can be sent as an e-mail attachment. This new equipment is available in the Historical Society room at the library for free use; bring your own floppy disk if you want to save the information. A big thanks to Jamie Brambley, Director of the Fulton County Library, who wrote the application for this up-to-date machine.

Library hours:

  • Monday/Wednesday 9:00 a.m. to 6:00 p.m.
  • Tuesday/Thursday 9:00 a.m. to 8:00 p.m.
  • Friday 9:00 a.m. to 5:00 p.m.
  • Saturday 10:00 a.m. to 2:00 p.m.

Please contact the Executive Director at the above postal address or email address for more information.

Photos of Our Library

microfilmreader.jpg (150885 bytes)         DSC02619.jpg (154614 bytes)

DSC02618.jpg (146134 bytes)         DSC02620.jpg (146210 bytes)

DSC02621.jpg (154812 bytes)         DSC02622.jpg (152522 bytes)