I am building a site for a friend that will showcase his mp3 collection (over 100) He wants visitors to be able to stream one (or even a play all button). He wants 5 different categories for the songs, but he wants to be able to update the categories as follows: upload new songs, and reorganize the lists by (date, song name, artist, etc). I am thinking flash is a good option to avoid dealing with (real player, quicktime, wmv, etc issues). Can I do this with just PHP/mySQL or is PHP/mySQL/XML/Flash an option?
i say i am happy with PHP/mySQL
what are you comfortable with ?
XML is good for a quick fix, as most flash mp3 players are written for XML…
it’s a little bandwidth quicker if you don’t have to formulate XML with PHP before entering Flash…
though it does give you an added means of checking your code, as you can write a default XML and make sure flash interprets it correctly, and have PHP output the query and write an XML file, which you can check is being written right…
so to sum up? read the post before 
well actually. I know a little bit of everything, but I am not an expert on any subject. So what ever I use, I 'll most likely struggle with for a while. I just want to be guided in the right direction to find out more. here is kind of what I think might work:
http://www.flashloaded.com/soundplayer.php
or
http://www.mp3.com/Enya/artists/3559/summary.html
the top rated albums section, important tracks, etc…
but I want to provide my friend with an admin page where he can upload songs, change order of songs, etc. without going into the xml file. Through some kind of form I suppose… Any ideas?
I haven’t been able to find such a system
