I need to develop a SQL Procedure,i am having 2 table one,with following details
userid
h1
h2
h3
h4
h5
h6
h7
date

and another table with following details
useid
per

why i need a procedure,because, the data to the first table is of follows
userid h1 h2 h3 h4 h5 h6 h7 date
1 p p p p p p p 2010-10-10
while data is updated in the table like new insertion or updation on the table the value in the table 2 should be updated
consider value of table2 is
userid per
1 50
it should be updated, the formula for update is (no of workhours-total hours end)/total no of work hours

nasıl ben bu MySQL yapabilir ve nasıl ben PHP yordamı kullanabilirsiniz?