my dropdown menu works fine, I mean it searches the database for the name choices and displays them. my problem is, it is not posting the "name" to the action script when submitted. any ideas..I know it must be something small that i missed.
<form name="test2" method="POST" action="untitled2.php">
<p>
<input type="submit" name="submit" value="submit">
<?php
$host = "db.database.com";
$user = "xxxxx";
$pass = "xxxxx";
$dbname = "xxxx";
$connection = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);
$sql = "SELECT DISTINCT(name) FROM xxxx";
$sql1 = mysql_query($sql);
echo("<select>");
while($row = mysql_fetch_array($sql1)) {
$name = $row[name];
echo("<option value=\"$name\">$name</option>");
}
echo("</select> ");
?>
</form>
