$query = "SELECT Name, Service, Birth, BirthPlace, Death, Cemetery1 FROM soldiers WHERE cemetery1 LIKE '%Bethel, VT' ORDER by Name ASC"; $result = @mysql_query ($query); $num = mysql_num_rows ($result); if ($num > 0) { // If it ran OK, display the records. while ($row = mysql_fetch_array($result, MYSQL_NUM)) { echo "

$row[0], service: $row[1];
born: $row[2], $row[3]; died: $row[4]; buried: $row[5]

"; } mysql_free_result ($result); // Free up the resources. } else { // If there are no responses echo '

There are no soldiers from this town in the database, sorry.

'; } ?>

---

See also a list of soldiers credited to Bethel.

Please visit the Bethel, Vermont website