So after a few google searches I found that I could create a very simple PHP script that creates an XML file that stores the media player's track data.
I started by creating the MYSQL table that will hold the track data - this will be used by the PHP script to populate the XML file.
My next step was to create the PHP file. The script can be seen in the image below.
Firstly, the SQL query gets the data from the music table and the ORDER BY keyword ensures that the latest track entered into the database appears at the top of the list in the mp3 player.
Then using PHP I have constructed the XML document, within which I have used a while loop in order to get the track name and file path from the database and insert them into the XML file.
Finally, in the MP3 Players ActionScript, where it previously linked to the XML document I have simply changed this to link to the php file.
After completing these steps I could then create a simple HTML form and accompanying PHP script so the admin can upload a new track to the MP3 player without having to edit an XML file and upload it back to the server.
I have also added a delete track form which simply deletes the record from the database where the name = the name typed in by the admin into the form.
