Hello! My company have created a website where employees will be able to take a test to earn points (CPD hours) which will be updated every time an employee takes the test. I am trying to find a way to update the number of CPD hours each employee has earned by using SQL, and displaying this on their profile page. The number of CPD hours awarded will need to be updated every time they earn more points. Every time they take the test, 2 CPD hours will be added. **Any help on this would be much appreciated! :) Thanks!**
If it's as simple as updating the hours each time they take the test, then you could update their hours in the data table by using something like: UPDATE CPDHours SET SQLHours = SQLHours + 2 WHERE UserName = 'Fred'