display record

[Anon]

How can i display a record based on a dynamic drop-down menu value.
My code just display one record and never changed when i choose another value from drop-down menu.

[matto]

an example:

<form ...>

<select name=user_id size=1>
<option value=1>first user</option>
<option value=2>second user</option>
</select>

<input type=submit ...>

</form>

user presses submit, now the script that is called, gets a variable named $user_id that contains 1 (if first user chosen) or 2 (if second user chosen).

now, produce your sql select:

$sql = "select name from users where id=$user_id";

execute this statement and display the name you get from your db - depending on the selection made.