Retrieve Names

[Dysan]

Hi,

I have a table that contains a list of people's first names. This table contains duplicate names.

Using PHP, how do I retrieve one instance of each of the names, stored in the "Names" column, and add them to a drop-down box?

[Weedpacket]

You retrieve them by using the appropriate database functions. See the manual for whichever are appropriate for you.

You add them to a dropdown box by writing the HTML. See any reasonable HTML reference.

[bradgrafelman]

For the query, assuming you're using a MySQL database, you might try a SELECT DISTINCT query.

As Weedpacket said, it's just a matter of outputting some simple HTML (output the SELECT tag, loop through the SQL result set and output the OPTION elements as you go, then output the closing SELECT tag).