php/mysql dilemma

[armando]

Hello...

I have a mysql database with 10 rows of CDs. Each row has five fields: cd_id, artist, title, label, genre. A user will visit a web page with an HTML form. The form will contain 5 checkboxes with a different genre next to each checkbox. When the user checks a box and submits the form, I need for the listings within the chosen genre to be selected from the database with only the artist and title fields displayed in the results.

I know there's a PHP variable/array combo that I should be using, but for the life of me, I can't get this to work. Ideas?

[Anon]

Hmm.. I may not understand you, but if I do, here's my solution (assume you named the group of radio button "genre_input"):

[gah, I thought you meant you needed to select multiple genres.. what a waste of time 🙂]

SELECT title, artist FROM cds_table WHERE genre='$genre_input'

Simple enough.

[armando]

That's about as far as I've gotten.

Where I need the most help is with the array code that would list out only the artist and title of the genre of CDs that was selected.