Hello
I'm making discography section for my site using php and mysql.
here is my db structure:
I have 3 tables- albums, tracks and albums_tracks
albums table holds information about albums, album name, release date...ect
tracks table is for song information, song name, lyrics..
albums_tracks is table that connects albums and tracks table.
EX:
albums_tracks table
albums_ID - track_ID
1-13
2-14
5-12
ect...
but I'm running into a problem with double disc albums. I would like to make something like this:
track list of cd 1
track 1
track 2
track list of cd2.
track 1
track 2
instead of
track listing
track1
track2
track1
track2
what I'm trying to say is that, I want page to return track listing for each CD separately.
maybe someone can help me with this...
thanks a lot
any kind of help will be apprediated.
