Support » Themes and Templates » Custom Dynamic pages from DB result

  • Hi:

    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.


Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Custom Dynamic pages from DB result’ is closed to new replies.