How to code cummulative score in Html, PHP and MySQL

Question

I'm working on school result portal. A result checking app. In each year, there are three kinds of exams. After entering scores for the exams, how can I display different columns for cummulative scores for the second and third exam?

Answer 1

If the data comes from the database, you can implement cumulative sum (running total) in mysql query with different techniques:
- using custom variable
- using window functions

https://popsql.com/learn-sql/mysql/how-to-calculate-cumulative-sum-running-total-in-mysql

Answer 2

Thank you