Hi there,

I am working with a dropbox, trying to get a value from it depending the selection made, for going to another page and proceed according to the selection made.

Dropbox elements are loaded from a MYSQL database, a simple query getting names. Almost all works fine, dropbox shows the element in database table, but nothing happens when I select one of them.
Here the code I am using: the query and the form including the dropbox. I am trying to associate to every dropbox element an option value using $count, in order to be able to identify wich option was selected and proceed accordingly when jump to admin_menu.php. As stated before, I can select dropbox elements, but nothing happens.

Any help would be greatly appreciated.
Thanks a lot!!!


<?php
$SQL = "SELECT School_Name FROM Schools";
$result = mysql_query($SQL, $db_handle) or die(mysql_error());
?>

<form action="admin_menu.php" method="post">
<select name = School>
<?php
$count = 0;
while ($row = mysql_fetch_array($result)){
echo "<option value='$count'>".$row['School_Name']."</option>";
$count++;
}
?>
</select>
</form>