I am building a list of songs, and the songs can be original songs, or cover versions of other songs. If the song is a cover version, I want to be able to get to the original artist, along with the title of the song and the cover artist.
Here are the tables/fields I'm working with: - songs id parent_id title - artists_songs id artist_id song_id - artists id name There is a hasAndBelongsToMany relationship between the artists and songs tables because a song can have many artists. Obviously artists can have many songs. When a cover version is added, the parent_id contains the id of the original song. This is how I would like to be able to display them: These are original songs: Rolling Stones - Gimme Shelter Kate Bush - Running Up That Hill These are cover versions: Sisters of Mercy - Gimme Shelter (Rolling Stones Cover) Placebo - Running Up That Hill (Kate Bush Cover) I have been struggling with how to make this work, any advice or tips to push me in the right direction would be much appreciated.
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
