Menu
Community /Pin to ProfileBookmark
@NogDogOct 14.2019 — #
Yes. It's even possible you then would not put the balance in the users table, but would calculate it on the fly by querying this new table. (It would therefore need to include a user_id column along with whatever else goes in it.)@NogDogOct 14.2019 — #@chrisjchrisj#1610061
The simplest thing would be to add a row to this new table each time a user earns (or loses?) credits. If we start with a really simple example, maybe it's just 3 columns:
Help with adding transaction tracking data
The php video web script that I’m trying to modify has a process where Users generate credit units from viewed videos.
The total ‘balance’ of credits is stored in mysql db table named ‘User’, in a column titled “balance”, with each total reflected in a users’ row, and the ‘balance’ total gets updated (goes up or down), depending on the activity of the credits.
However, if 2 credits get added to the balance, for example, there is no tracking of what type of activity caused the balance total change.
I believe a separate table that gets a new row inserted for each transaction, that affects the amount, should be created? but I don’t know how to go about doing that. Any guidance you’d like to share is appreciated.
What else might this need? Or do you have a better/another idea?
I look forward to all comments/suggestions.
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogOct 14.2019 — #>@chrisjchrisj#1610047 I believe a separate table that gets a new row inserted for each transaction, that affects the amount, should be created?
Yes. It's even possible you then would not put the balance in the users table, but would calculate it on the fly by querying this new table. (It would therefore need to include a user_id column along with whatever else goes in it.)
0
@NogDogOct 14.2019 — #The simplest thing would be to add a row to this new table each time a user earns (or loses?) credits. If we start with a really simple example, maybe it's just 3 columns:
user_idtransaction_timestampcredits<i>
</i>SELECT SUM(credits) AS current_credits FROM credit_table WHERE user_id = 123;