Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › How can I configure a music album download?

How can I configure a music album download?

Thread began 4/22/2013 7:59 am by danielsebas | Last modified 4/29/2013 7:40 am by Jason Byrnes | 1004 views | 5 replies |

4/22/2013 7:59 am | #1 danielsebas

How can I configure a music album download?

Hi, I am working on a Digital Music Store so I can sell single tracks and albums, but how can I configure the store so that when someone buys the album He can download all the songs in it separately?

4/22/2013 8:14 am | #2 Jason ByrnesWebAssist

you would need a linking table to assign the tracks to the album

albumtracks:
albumtrackID - primary key
albumtrackSongID - realtes to the songs.songID
albumtracksProductID - relates the products.productID that is the album ID number

then use a join query to return the songs that reate to the selected album.

http://www.w3schools.com/sql/sql_join.asp

4/28/2013 9:39 pm | #3 danielsebas

Thank you Jason, please guide me a little more, I'm completely lost. I already created the table.

4/29/2013 7:06 am | #4 Jason ByrnesWebAssist

What specifically do you need help with? What part are you lost on?

4/29/2013 7:26 am | #5 danielsebas

In which page should I make the table joins? In the download center? Or in the admin part where you insert the a new product? If you have any guide or tutorial will be great.

4/29/2013 7:40 am | #6 Jason ByrnesWebAssist

the join should be on the download center page.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.