solution? PHP & MySQL

[ale1981]

Ok, I will try and explain this the best way I can!

I am making a website for a football (or soccer) league. I have done ok so far, so that the admin of the league can add, delete, edit teams, leagues, referees, players, etc

Now my problem is I need help on the fixtures, results and automatically generating the league page?

Adding the fixtures should be pretty simple;

In the database I will need the following tables

fixture_id (Primary Key)
fixture_league_id (The league the fixture is in)
fixture_type (Home or Away)
fixture_home (Home Team)
fixture_away (Away Team)
fixture_kickoff (Kick Off Time)

(anything else)?

The problem will be the results, how to add the results to the database then from the results auto generate a league table.

Maybe I need to add a Win Lose Draw GoalsFor GoalsAgainst to the teams table?

Hope I explained well enough.

ANY help with this will be GREATLY appreciated as I am kinda stuck and not really an advanced PHP MySQL developer.

Thanks.

[ale1981]

nobody have any ideas?????

[The Hobo]

I'm not sure what you're talking about?

What is this 'automatically generated page' supposed to look like?

[phpman]

well if I understand him correctly.

what you do is have a page that you can insert all the results and then by submitting that form it will insert the contents.

then you have another page where you goto that will query the db to get those reults that you just inserted.

pretty easy as all you do is insert results to database, query (select) results out to the results page to view.