Hi,

I'm sure this is simple, but it's eluding me as many things do as a newbie. Anyway, I've been having trouble in my PHP code so I'm trying to at least get the right MySQL query, and this works for the info I need:

SELECT artist.id, medium FROM artist, medium, artistmedium WHERE artist.id=medartid AND medium.id=mediumid

and it gives me a very nice table with artist id #s on the left, and the medium they work in on the right. When one artist works in more than one medium, then they have more than one row like so:

ID medium
-- ----------
1 | painting
2 | sculpture
2 | computer web/based
3 | ceramics
4 | painting
4 | drawing
4 | installation
.
.
.
and so on.

What I would like to have is something like this:
ID medium
-- ----------
1 | painting
2 | sculpture, computer web/based
3 | ceramics
4 | painting, drawing, installation
.
.
.

How can I do this?

Thanks,
Satre