dropdown

[scottbarry]

First I would like to help everyone that has helped me so far.

<form name="form1" method="POST" action="submit

<p> name: <input name="name" type="text" id="name">
<p><input type="submit" name="submit" value="submit">
</form>

as you can see, the user types in a name and it searches the name field in my database with submit.php and returns with the correct data.

what i would like to do is have a dropdown menu that will list all entries in the "name" field.

any suggestions?

[stew]

$sql = "SELECT DISTINCT(name) FROM table";
$sql1 = mysql_query($sql);

echo("<select>
while($row = mysql_fetch_array($sql1)) {
$name = $row[name];
echo("<option value=\"$name\">$name</option>");
}
echo("</select>

[scottbarry]

I am getting a parse error on

echo("<option value=\"$name\">$name</option>");

[stew]

Originally posted by stew
$sql = "SELECT DISTINCT(name) FROM table";
$sql1 = mysql_query($sql);

echo("<select>");
while($row = mysql_fetch_array($sql1)) {
$name = $row[name];
echo("<option value=\"$name\">$name</option>");
}
echo("</select> ");

[scottbarry]

thank you..that brought up the correct dropdown menu..

but..where do i fit in the submit button and the line

<form name="test2" method="POST" action="submit.php">

[scottbarry]

does anyone have any idea how fix the above post?