Hey guys, currently I understand just a bit of adding numbers from mysql together for a table, but I’m looking to add together only numbers that correlate with a certain persons name together to show in a table on my site.

My mysql has (Name, and points, as well as a timestamp)

I am looking to make it so, if “Joe Bob” was given 10 points two different times, and “Bob Joe” was given 10 points, it would show up as 20 on the table, while also showing “Bob Joe” as having his own 10 points as well.

I understand the easiest way to do this is to use the update function and just update each person when they are given points, but I am working on making it so after a set amount of time (for example 2 weeks) the points would not be shown anymore, that is why I am using the timestamp.