php - Attentance management using MySQL Procedure how to do? -

I need to develop a SQL process, I am having 2 tables with the following details - userid < Br> h1
h2
h3
h4
h5
h6
h7
date

and another table with the following details < Usage
Per Page

Why do I need a process, because the data in the first table is as follows - userid h1 h2 h3 h4 h5 h6 h7 Date
1pppppppp 2010-10-10
New entry or update in the table in the table As the date is updated in the data table, the value should be updated in Table 2 / value of Table 2 - User ID per 1 1 50

How can I do this in MySQL, and how can I use this process in PHP?

You can use the trigger instead of inserting the trigger or after the update operation will be asked in my experience , I only use the store process or transaction using only some complex database manipulation.