Using a HTML table to update mysql records
Posted on 2009-04-15
I am currently designing a website that will display league standings, sorted by point value. I have worked out how I can display the data in a table now and in the way that I want, but the website has to be updatable. Is it possible to design a table that will update points when entered into a field?
For example, would it be possible to grab the team names and place them in a dropdown menu, then use a seperate text field to input the point value, click submit which would add that value onto the existing value for the relevant team?
Either that, or display the teams in a list on a page so you can edit multiple records at any one time?
I have been looking around but I am struggling at the moment to find an answer
The fields I am using in my table are:
tname - team name
points - current points.