drop down content

[tn_prasad]

hi,
i need to get a list of values from the DB & display in a drop down.
For exammple i ha ve 4 values in the DB ""a,b,c,d""
Now i need to diaplay them in a drop down menu for a user to select any one of them.
how can i do this plz help me.
tnx
prasad

[Anon]

<select name = name>
$query = "select * from yourTable where where_Condition";
$result = mysql_query($query);
while($data = mysql_fetch_object($result)){
echo "<option value = '$data->name'>$data->fieldnamewith-a-b-c-d-values</option>";
echo "</select>";