I have a site running on CodeIgniter right now, but I want to migrate it to WP. I've figured out all the other parts except the dynamic pages that I'm generating now.
I'm working on a singer website who has many albums and many songs (over 200). Some of the songs appear in multiple albums, ie “Best of” and Compilations.
I have 3 tables, albums, songs, songs_to_albums.
This gives me the posibility of assigning different songs to different albums.
All songs have lyrics, most have videos , either on youtube or on our server.
All songs and albums have star ratings and description.
I need an Albums page where it extracts all albums.
Each album is linked to an “Album-specific” page which extracts all the songs that are in the album, plus description, rating….
Each song within an album is linked to “Song-specific” page, which extracts specific song info from the db, ie title, description, and albums it appears on.
I need a page that lists all the songs dynamically, indicating on which albums they appear.
I don’t want to create static pages for albums and songs, they must be dynamic.
Currently all these pages, SQL queries, etc exist, so I need to know how to integrate them into WP.
I realize I have to create some custom solution in WP, but since I'm not @ that advanced in WP I don't even know where to start !
Thank you in advance for your help.