[Resolved] SQL / PHP / Dropdown menu

[Feffik]

Hi,

I have php 4.3.4. and mysql database installed.

I want have a dropdown menu on a page, with the names of the users in it. (it gets the users from the database).
The thing i wanna do is this:
when a user is selected from the dpd menu, that in the textfield/form below the number of this user is displayed.
(which will have to be searched in the database also).

anyone who could help me with this... hopefully!
I'll paste a part of the code which I got:

echo "<FORM METHOD=\"post\" ACTION=\"$_SERVER[PHP_SELF]\" NAME=\"test\">\n";
echo 'Naam: <SELECT NAME="naam" size="1" onChange="Choice();">';
$result = mysql_query("SELECT naam FROM members ORDER BY naam ASC");

   while($row = mysql_fetch_array($result)) {

echo '<OPTION VALUE="' . $row['naam']. '">' . $row['naam'] .'</OPTION>';
}
echo "</SELECT><BR><BR>";

echo "Nummer: <INPUT TYPE=\"text\" NAME=\"nummer\" VALUE=\"$nummer\" SIZE=\"10\" MAXLENGTH=\"10\" DISABLED><BR><BR>\n";

Beneath this there are some more inrelevant form/text fields...

[Feffik]

I've been searchin the web a lot, not really finding what i need.. but i changed the code to this: but still doesn't work.. any1 can help?
I think the part where i set the nummer value is not correct... or something..

<?
echo "<FORM METHOD=\"post\" ACTION=\"$_SERVER[PHP_SELF]\" NAME=\"test\">\n";

$vl="";
if(isset($POST['naam']))
{
$vl=$POST['naam'];
$sql="select nummer from members where naam='$vl'";
$rs=mysql_query($sql);
}
?>

<script>
function resubmit()
{
document.test.action="cijfers.php"

// document.test.submit()
test.nummer.value=$nummer
}
</script>

<?

echo 'Naam: <SELECT NAME="naam" size="1" onChange="resubmit()">';
$result = mysql_query("SELECT naam FROM members ORDER BY naam ASC");

   while($row = mysql_fetch_array($result)) {
   /* laat items zien  */

echo '<OPTION VALUE="' . $row['naam']. ' ">' . $row['naam'] .'</OPTION>';
}
echo "</SELECT><BR><BR>";

if($vl!="")
{
$row=mysql_fetch_row($rs);
$row->nummer = $nummer;
echo "Nummer: <INPUT TYPE=\"text\" NAME=\"nummer\" VALUE=\"$nummer\" SIZE=\"10\" MAXLENGTH=\"10\" DISABLED><BR><BR>\n";

}