Coldfusion query calculation

I am currently working on a project for a sports tournament, where they would like to have the scores and schedule posted on the web. This tournament is setup with currently 2 divisions “Pool A” and “Pool B”, with between 5-6 teams in each pool. What I would like to do is have it setup so the user inputs the scores for each game with a total of 25 regular games. After these games are finished I would like to code it so that the page show the teams that will be facing off agents each other in the finals automatically, and add this information to the database so that after these games are finished the user will be able to just enter the scores. I know it would be allot easier and probably quicker to just get the user to enter the final game info, but I was hoping to try to set something up like this, for an experiment.

I will greatly appreciate any suggestion.

Thank you

What criteria is the system to use to determine who is playing in the finals?

You could write this as stored procedures directly on the database, or you could write CF code to query the database and determine who is playing. But I don't understand how you plan to determine the final players, and how they will be matched up.

They have it schedule out, so that the team in the 5th position in PoolA will play the team in the 5th position in PoolB and so on up to the 1st position on both sides.

As long as you understand the criteria for how the teams will be matched up, you can definitely write SQL queries and/or CFML code that will automatically generate a match up page for you.