I am looking at developing a website for a local SNOOKER league on a charity basis (as a hobby, and hoping to learn a little at the same time)...
I would like each team in the league to have it's own page where they could define their team ... ie: Player1, Player2 etc ... Then each week the particular weeks fixtures are displayed and (from drop down boxes) player1 can be chosen to have lost or beat Player4 (for example) from the opposing team.
When six matches (of that fixture) have been added the result is calculated and the league table is automatically updated. When ALL fixtures (for a particular week) are filled, the 'input results' page would display next weeks fixtures.
Each team captain would have a password to input their teams results, team members (anyone) would be able to view results of fixtures and individual matches within fixtures, and the (automatically updated) overall league table.
I would also like to include a box for breaks of 30 or over for individual players within the 'fixture' screen.
In broad terms ... Is DBman right for this job, or should I be looking at using another method. Has it been done before with dbman ? Also, the computer logic of sorting the league table alphabetically and then with different criteria of overall points, games won etc would be beyond me without some sort of a start ...
Paul
I would like each team in the league to have it's own page where they could define their team ... ie: Player1, Player2 etc ... Then each week the particular weeks fixtures are displayed and (from drop down boxes) player1 can be chosen to have lost or beat Player4 (for example) from the opposing team.
When six matches (of that fixture) have been added the result is calculated and the league table is automatically updated. When ALL fixtures (for a particular week) are filled, the 'input results' page would display next weeks fixtures.
Each team captain would have a password to input their teams results, team members (anyone) would be able to view results of fixtures and individual matches within fixtures, and the (automatically updated) overall league table.
I would also like to include a box for breaks of 30 or over for individual players within the 'fixture' screen.
In broad terms ... Is DBman right for this job, or should I be looking at using another method. Has it been done before with dbman ? Also, the computer logic of sorting the league table alphabetically and then with different criteria of overall points, games won etc would be beyond me without some sort of a start ...
Paul
Little league Snooker ... Help