I've been working on a project for some time now, a "Discography" (or perhaps "Songography" would be more appropriate) that started with one artist that has now expanded to a few others on the same label. I've been using XML files to store the information (a file for each artist), and given the artists often work together or appear on others' songs together, it has resulted in a lot of duplicated information as well as some inconsistencies in artist names and whatnot. That's why I've begun looking toward PHP+MySQL as an alternative to XML+XSL, hoping to cut down on the amount of duplicated information (seeing as the same song could be linked to one... or all of the artists, and still only need one entry) and spelling inconsistencies and such (since each artist would only need one entry, and not have to be typed for each song, etc).
Though as I previously indicated, I have yet to fully grasp the knowledge needed to make such a move. Especially when it comes to trying to sit down and design the database to hold the information. I have some general ideas as to how it should look, but every time I sit down to try and hammer out the details... I end up just sitting there scratching my head. Even if I were to manage to get that all set up, I imagine I would still have a little trouble on the PHP side, when it comes to interacting with said database.
That's why I'm seeking someone who actually knows what they're doing when it comes to messing with both of these. Hoping they may be able to provide some tips, point me in the right direction, or may be willing to take a more hands-on approach to trying to help me on this project.
If you're someone that knows a thing or two and may be able to help, or are just curious as to the project I'm working on, you can see the current XML+XSL solution here: StrangeMusicHQ, there you can get a sense of the needed layout of the page, as well as the current storage structure (via View Source to see the XML information). If anyone can and is willing to offer help (in whatever form), it would be greatly appreciated. If not, then I still appreciate you taking the time to give this a read through.
Thanks,
Mizery_Made


