MySQL 3 Table join question...

[eluser]jedd[/eluser]
[quote author="f244" date="1267872872"]
I get a result back with 3 rows, one for each artist:

Row 1 -> Title, Artist(1)
Row 2 -> Title, Artist(2)
Row 3 -> Title, Artist(3)

Is there a way to modify the query so I can have the results as a single row with all the artist names either in separate fields or in an array or something like that?
[/quote]

You could, but you probably don't want to. I suspect you have a view problem here, not a SQL one. That is, you have a certain way of handling data in your view, and you just don't yet know the best way to handle this (new) format of the arrays.

Have a read of this thread: [url="http://ellislab.com/forums/viewthread/125879"]http://ellislab.com/forums/viewthread/125879[/url]