Hi there,
I am currently making a LiveTicker in php. LiveTicker is a dynamic website that shows live scores of soccer matches.
I am mostly done with the main web interface (the one that shows the matches and the scores). Now I am building the Admin interface, where you are able to add matches, delete matches, and most important: alter match score. The last one is the biggest part of the entire program, and it's there I have problems.
I have the following mySQL tables:
matches (matchID, hometeamID, awayteamID, homescore, awayscore)
The table contains matches. In the "alter match" interface, only the last two fields need to be changed.
What I want to do in the "alter match" interface is this:
First I choose a allready made match by using a ComboBox. I then press a button wich reads the selected match data and fills the input fields below with the score data. When I change the data, I press the Update button, and the new data is updated to the tables.
What is the best way to do this? I know how to get data from a table and put them into variables, but how do I take those variables and make them go into the input fields - so that the input fields (text boxes) are automaticly filled out once I chooe a match from the combo?
Thanks in advance
I hople you understand what I want to do, please ask if you don't understand something.
