dropdown help

[mmmsabeel]

hi everyone...iam sabeel...

i have a drop down which is dynamically populated from a field(phoneNumber) in the mysql table...

and i have a dynamic table which lists all the values from the mysql table.....

now here is my problem....

when i select an option in the dropdown(phoneNumber)..then the values in the dynamic table should be, select all from mysql table where phoneNumber = the value selected in the dropdown....

thanks in advance.. :-)

[sDJh]

code 1 (The HTML-Form):

<form action="code_2.php" method=post>
<select name="phonenumber">
<option>Nb1</option>
<option>Nb2</option>
...
</select>
<input type=submit>
</form>

Code 2 (Selecting the Values in PHP):

<?
$phonenumber=$_REQUEST["phonenumber"];
$res=mysql_query("SELECT *  FROM `table` WHERE `PhoneNumber`='".$phonenumber);
?>

[mmmsabeel]

thank you so much sDJh....your code really helped me.....