Number Guessing Game. Did I choose a wrong way to do it?

Hello,

not really an issue as I have just finished this task, just wondering if my first choice of doing this task was flawed. Basically, my logic was to create 2 tables: 1 for players, times played and their best game, another database for current game (always 1 row with current number and number of guesses).

I did have my doubts if creating a table with 1 row only was a good choice and those doubts were kinda proven right when my tests wouldn’t pass and I decided to try another way of storing the current number into a constant and making number of guesses a variable.

Just wondering if my first attempt was really such a stupid thing to do lol.

yeah usually ‘current info’ is not stored in a table. We store things we want to remember in tables and current values that are only valid for now in variables.