Selecting things only once

[Shawazi]

This table I have with cds has a column with the artists name and genreid. I want to form a list of all artists with a certain id number. The problem is that of course one artist will have multiple CDs with the same genreid. This makes the artist name pop up on the list more than once. What is the command to make it not repeat? I forgot it >.<

[HalfaBee]

I think DISTINCT is what you are thinking of.

HalfaBee

[amcgrath]

or GROUP BY... no wait, I take that back, unless you are not selecting the CD info...

amc

[lazzerous]

why not break up the tables?

have a table for artists:
id int(5) unique auto_increment
f_name varchar(20)
l_name varchar(20)

have a table for genres:
id int(5) unique auto_increment
genre_name varchar(20) unique

have a table for cds
id int(7) unique auto_increment
cd_name varchar(20)
genre_id
artist_id

make sense?