selecting option

[Anon]

hello. I'm trying different ways and ideas for my webpage. I am using php and mysql. What i'm wanting to do is for example, list all the departments in my online store (read from the database with select, that part i know how to do), but also make it so they can choose one of those from the list. I know I would have to somehow make php and a form work together but how? I could do this alot simpler if i didnt want to list the deparments first but if possible I'd like to. If anyone has an idea on this or an answer let me know. thanks.

[[deleted]]

<form method="post" action="<? echo $_SERVER['PHP_SELF'];?>"

<select name="deps">
<?
$sql = "SELECT name FROM departments";
$result = mysql_query($sql);
while($row = $mysql_fetch_row($result)){
echo "<option value=\"$row[0]\">$row[0]</option>";
}
?>

</select>
<input type="hidden" name="redir" value="true">
<input type="submit">
</form>

This would generate a form with a dropdown box where the names of the debs can be selected.

I think now you want the user to select one and then be redireted, or not ?

so far

ali