Hi Guys,

I'm trying to create a league table system for my football content managed system:

So I have my league table:



I want to then create an admin screen which I can enter the results in:



and then when I hit submit the table is updated accordingly.



I have not got the feintest where to start and to create rules such as +3 points for every win, add 2 goals every goal conceded -1 etc. Can anyone point me in the right direction?

Thanks

Chris

have u created the ADMIN Area ?

A good starting point is to design your database carefully - how will you store the data about the teams? One way is to build a database that looks a lot like your league table, and chnage the values accordingly - this is quick and easy but you could easily end up with inconsistent data i.e. numbers that don't add upp as they should etc. Another approach is to record info in your db about the teams, and then log the individual match results in another table, with a record of which teams played and the score etc. Then you can generate the league table from this each time round with no consistency troubles.

Once you have designed your database structure, it is easier to see how to start building the scripts to manipulate it properly.

Smells of school project