Designing a simple website for a game as a learning project. The challenge I have is that I want the game host to specify how many rounds the game will have. This will be an input and then based on this we will record our scores in generated fields. Sometimes the game will have 4 rounds and sometimes 6 and at the end the system will sum up all the points. Is it good to create a game table in my database which will have 6 columns (they will not always be populated due to different number of rounds) or shall I look at other options? Any tools I could use to make it more dynamic? I’m brand new so a lot to learn.
The only idea I have is to create a table with 6 columns. I assume this will work with this project but will not if a game goes for 20 or 30 rounds.