Potter's Field Index Search 1871-1953

Cemetery Records of the Suffolk County Almshouse, Yaphank, NY

Results of the Search of the Potter\'s Field Cemetery Records'; $results_negative = "No results were found for your search. Check the spelling and try again or contact the Historic Documents Library for additional information."; $results_tableheading = ''; $table_end='
Line No. Last Name First Name Date of Death Age at Death in Years Old Marker No. New Marker No. Comments
'; //print $results_heading; print $results_tableheading; $count=0; while ($searcharray = mysql_fetch_array($result)) { $first_name = $searcharray["first_name"]; $last_name = $searcharray["last_name"]; $date_of_death = $searcharray["date_of_death"]; $age_at_death = $searcharray["age_at_death"]; $new_marker = $searcharray["new_marker"]; $old_marker = $searcharray["old_marker"]; $comments = $searcharray["comments"]."\n"; $count++; $results_line = " $count $last_name $first_name $date_of_death $age_at_death $old_marker $new_marker $comments "; print $results_line; } print $table_end; print $again; } function choose_records() { $lname=trim($_GET['last_name']); // $qname=addslashes($lname); $sql = "SELECT * FROM pottersfield WHERE last_name = '$lname'"; $result = mysql_query($sql) or die (mysql_error()); $results_negative = 'No results were found for your search. Check the spelling and try again or contact the Historic Documents Library for additional information.'; $results_tableheading = ''; $table_end='
Line No. Last Name First Name Date of Death Age at Death in Years Old Marker No. New Marker No. Comments
'; $count=0; while ($searcharray = mysql_fetch_array($result)) { $first_name = $searcharray["first_name"]; $last_name = $searcharray["last_name"]; $date_of_death = $searcharray["date_of_death"]; $age_at_death = $searcharray["age_at_death"]; $new_marker = $searcharray["new_marker"]; $old_marker = $searcharray["old_marker"]; $comments = $searcharray["comments"]."\n"; if ($count == 0) { print $results_tableheading; } $count++; $results_line = " $count $last_name $first_name $date_of_death $age_at_death $old_marker $new_marker $comments "; print $results_line; } print $table_end; if ($count == 0) { print $results_negative; } print $again; } $form='
List all records:
Select a record:
Last Name:

'; //function rubino_print($age_at_death, $singular, $plural) { //if($age_at_death <= 1) { // return "$age_at_death $singular"; //} //return "$age_at_death $plural"; //} if($_GET['submitted']) { $conn = mysql_connect("localhost", "mptakacs", "roanoke"); mysql_select_db("mptakacs"); $choice=$_GET['forminput']; if ($choice == "allrecords") { all_records(); } else { choose_records(); } //Can this ELSE go with the WHILE or will the negative response print when GET is not submitted //I can't get the form to take the variable name $form. } else { print $form; } ?>

Search Again

Home

Valid XHTML 1.0!