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.

Make the text boxes have a value= in them and this should equal whatever the variable is that is pulled from the database so something like

<?php if (isset($homescore)) { echo "value=$homescore"; } ?>

This would make sure that if the variable $homescore was set, it would output it into the text field. This code needs to be within the <input> tags

Craig