$connect = mysql_connect(“localhost”,”fmojhvmy_inst”,”P@55W0rd”); // connection location to the db or display error
$db = @mysql_select_db(“fmojhvmy_inst”,$connect); // connecting to the database or display error message

$result = mysql_query(“SELECT * FROM `instrument` WHERE `id` = ‘”.$id.”‘”);
if (!$result) { // add this check.
die(‘Invalid query: ‘ . mysql_error());

// All
$sql = “SELECT id FROM `instrument`”;
$result = mysql_query($sql);
$all = mysql_num_rows($result);

// OTS
$sql = “SELECT id FROM `instrument` WHERE orientation = 5”;
$result = mysql_query($sql);
$ots = mysql_num_rows($result);

// Circular
$sql = “SELECT id FROM `instrument` WHERE orientation = 4”;
$result = mysql_query($sql);
$cir = mysql_num_rows($result);

// Upright Cornets
$sql = “SELECT id FROM `instrument` WHERE instrument_type = 3 AND orientation = 3”;
$result = mysql_query($sql);
$upcor = mysql_num_rows($result);

echo ‘
At a glance:

HMMF maintains a playing collection (in other words, all instruments are maintained for performance, with the exception of the few instruments being restored at any one time) of ‘.$all.’ brass, woodwinds and drums; all antiques with the exception of 5 reproduction snare drums; some of which are:

‘.$ots.’ over-the-shoulder horns
‘.$cir.’ circular instruments
‘.$upcor.’ upright cornets
1 Schreiber teardrop horn – an Eb bass
2 Ophicleides in C, a Quinticlave in Eb and a Keyed Bugle in Bb/C
4 Civil War era snare drums, one played by the 24th Wisconsin band, one by the 5th Alabama
2 Presentations to Wisconsin Regiments; an OTS Eb Cornet from the 22d, and a Bb bass from the 24th
1 Revolutionary War snare drum and 1 War of 1812 era snare drum
2 instruments original to the band – an upright alto played by the Brodhead Brass Band ca. 1858, and an OTS Bb bass played by Joseph Smith in the original 1st Brigade Band in 1864-5
A page detailing instrument conservation and restoration may be found here. Instrument Restoration

Anyone not familiar with the many different types of brass instruments and valve configurations of the 1860’s civilian and military bands can get a short pictorial explanation may be found here. Instrument Configurations.

Links to the separate sections are listed below. Enjoy!

Instrument Collection


$sql = “SELECT * FROM `instrument_type` ORDER BY `id`”;
$result = mysql_query($sql) or perish(“Unable to execute SQL query on database ::
\r\n” . mysql_error());

while ($row = mysql_fetch_array($result)) {

echo ‘