MySQL dropdown

[Ken2k7]

Is there a way to make a dropdown by getting the options directly from the database? And I'm using this as a form so it has to have a name so I can call upon the value and do something to it.

 

Example to what I want to do:

- I have a database table named members and in that table, it has 3 columns - name, age, sex.

 

What I want to do is make a dropdown inside a <form> using the data from the database. And then when the person selects the name of the member and presses submit, it deletes the row with that name from the table and the database.

 

Thanks in advance.

[dbo]

Yes.

 

Query the database pulling out the information for the value and display of the dropdown. Loop through the result set and output it in the format of <option value="$value">$text</option>