radio button list from MySQL with PHP

[satre]

Hi All,

Is there a way to use PHP to make a radio button list from data in a MySQL table? I'd like to be able to add data to the table in the future and have the radio buttons added automatically. I've been using code for a popup menu that fetches an array whose members correspond to a unique ID number, but the design I'm working on would work best for radio buttons. This is for an artists portfolio website of a lot of artists and I'm making a search page that includes parameters such as style (abstract, representational, conceptual), medium (painting, sculpture, ...), and materials (oil, acrylic, stone, ...).

Example:
Looking for artists that work in:
painting (button)
sculpture (button)
works on paper (button)
collage (button)
.
.
.
.
and so on

Thanks!
Satre