How do I create a dropdown

[aggiefan]

I need to create a dropdown in a template that's populated from a database table. The table only has one column and I need it to pull and list each row in that column.

I just need it to list what's in there -- don't need it to do anything upon clicking. How can I do this? I haven't been successful in my futile attempts.

Advice for what goes in the php file and template would be awesome! Thanks!