Hi, I'm creating a game where users play daily & earn points. I wanted to record the scores of each user each day for a month. At first, I thought to create 31 columns within the table & store the score in the appropriate date field. But, I think it is a bit messy. Is there any other alternative where I could I achieve the same thing. Any help is appreciated.
Jump to Post
You are correct, making a table field for each day of the month is messy and is bound to cause issues. You could create a new table called user score that links to the user table and stores the user_id the date and the score for that day. Then you …
All 4 RepliesReply to this topic
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.