halo-eleven

Thanks, but i think at first i need to change my database structure or add some tables... :(

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.