$query = "SELECT Name, Town, Service FROM soldiers, towns WHERE Town LIKE '%Bethel, VT%' AND TID=towns.ID 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], credited to $row[1]; service: $row[2]

"; } 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 buried in Bethel.

Please visit the Bethel, Vermont website