A question To The Wise...

[justin007]

Dear knowledgeable people...

I am a complete novice when it comes to coding so to begin with I would like your help in answering a question that relates to the structure of which my project needs to proceed..


The basics are:

I have a piece of audio broadcasting software.
The software plays music to whoever wants to listen across the net.
When a song is played the software updates a MYSQL database.
The information that is sent to the database consists of data such as “song name” “artist” etc.. etc..

What I would like to do:

I would like this information to be sent to my web page (yet to be designed) and it be updated when a change is made to the database (I.e. upon a song change) or updated at logical times (maybe every 15 seconds).. either way it is important that the user viewing the web page does not have to refresh the page to see the new results from the database.

My understanding:

The way I understand it is that …
MYSQL stores the information created by the broadcasting program.
Then I need a PHP script to take this information and store it in a logical way on my server.
Next I need some form of JAVA to take this information and place it onto the web page for the user to view. (I also believe that I need Java as it enables real-time updates without the need to refresh the page manually)
That is about as far as I have got..

What I would really like is for someone to explain if this process is correct so I can go about learning the programming languages in a structured way..



What do I already know...

I have a server set-up
It has, MYSQL+PHP+APACHE all running and I can access these programs/services.
I have managed to copy/destroy and paste other peoples PHP work and I am able to get information from the MYSQL database.. i.e. “the most recently played song” and “the last 6 played songs” and display them on screen.

Where do I go from here?. Am I right in thinking that this structure is correct... How big is this can of worms..

I hope you can find the time to help me head in the right direction..


regards

Justin..

[dglienna]

Might want to check with a LAWYER before you start. Unless you give music away (or are performing SOLO), you are liable for things...

EDIT: At least in the USA