Creating Tipping Competition

[airforcefc]

Hello,

I am new to MYSQL and PHP but am learning fast. I am looking for a Tutorial or any guidance and help to find code that will help me create and structure a Database and PHP so I can have a working tipping competition where people put their tips in each Round ( 22 Rounds in total ) and using an admin area where the Administrator can put in the correct Team winners for that round. By doing this will show the results of each round by round and a total score for each member. I would like to Sort by Total Points Winner so that the leader of the competition is always on top of the table. If anyone out there could help me please post replies so that it can also help others out there as I cannot find anything on the net.

Basically in a nut shell I am after the following but if anyone has an easier way please let me know because it does take up alot of tables and fields:

Database: Tipping

Table: Members
Fields: ID - USERNAME - PASSWORD - NAME


Table: ROUND01
Fields: ID - TEAM01 - TEAM02 - TEAM03 - TEAM04 - TEAM05 - TEAM06 - TEAM07 - TEAM08

Table: ROUND02
Fields: ID - TEAM01 - TEAM02 - TEAM03 - TEAM04 - TEAM05 - TEAM06 - TEAM07 - TEAM08

-------So on till ROUND 22--------

Table: AdminResults
Fields: RNDNo - TEAM01 - TEAM02 - TEAM03 - TEAM04 - TEAM05 - TEAM06 - TEAM07 - TEAM08

---------------------------------
Table:Results
Fields: ID - TotalRnd01 - TotalRnd02 - TotalRnd03 - etc etc then finally - TOTALPOINTS per Member

---------------------------------

Hopefully this makes sense to everyone, the ID would be unique to all Tables and the final results would be a sum from the Winners inputted by the Administrator at the end of each week with the Predicted winners from the Members inputted before the games. Then Giving a final result per Round displayed on a LADDER using PHP including a TOTAL POINTS Field that adds up each round points that members won.

If anyone could help with getting this together that would be much appreciated. Even if you help me in the right direction and I am able to do the rest that would help.

Thanks in advanced!!!:)

[chazzy]

I've read this topic a couple of times to decide how to best answer this.

You're looking for something that I would say is too specific. There are plenty of guides out there for creating web apps using MySQL/PHP, and numerous books on the subject as well. I think the only category your stuff would really fit into would be that category. I honestly can't list anything that is a guide for creating your specific app.

[airforcefc]

Thanks for the reply,

How could I simply add 1 field from 1 table to another field in another table and produce the total as an echo or in a new table? Juts need to know how to add fields and tables together to produce an answer or total,

Thanx