Can someone please help me get the drop down box to actually update my table?? The website address is Murfreesboro Bars if you want to see the code at work... but When you select the bar's name in the drop down it does not update the table it doesn’t do anything.

I have searched and searched and searched and can’t find any code that will help me in this situation. I was told JavaScript is what I need to get the box to actually work but I can’t find the code for that. Please Help

$connect = mysql_connect("", "username", "password") or
die ("Hey loser, check your server connection.");
// Write out our query to get the list of bar names from our DB.
$query = "SELECT Bar FROM Test";
// Execute it, or return the error message if there's a problem.
$result = mysql_query($query) or die(mysql_error());

$dropdown = "<select name='Bar'>";

//fetch_assoc will get the rows from the $result and put them into an array
// the while loop then loops through the array wrapping the html code around the results
// thus generating the dropdown with a list of your bar names
while($row = mysql_fetch_assoc($result)) {
$dropdown .= "\r\n<option value='{$row['Bar']}'>{$row['Bar']}</option>";
$dropdown .= "\r\n</select>";
echo $dropdown;
$query="select * from Test";
$result = mysql_query("SELECT * FROM Test where City='Murfreesboro'");
<table border=1 style="background-color:#F0F8FF;" >
<caption><EM>Murfreesboro Bars</EM></caption>
<th>Bar Name</th>
echo "</td><td>";
echo $row['Bar'];
echo "</td><td>";
echo $row['City'];
echo "</td><td>";
echo $row['Address'];
echo "</td><td>";
echo $row['Phone'];
echo "</td></tr>";
echo "</table>";