fui_koh
07-07-03, 09:01 AM
hi,
the case is php with mysql.
coding for the calculation.
e.g. a) an employee has 18 days leave a year...
b) an employee take leave from 3/6/03 to 6/6/03 ( count the duration and the balance of the leave).....
<in my web site exmple>
from date: xx/xx/xx (empty field)
to date : xx/xx/xx (empty field)
duration : <result>
balance : <result>
[submit] <button>
after insert the from date and to date and click submit, the duration and the balance of leave will automatically show
the case is php with mysql.
coding for the calculation.
e.g. a) an employee has 18 days leave a year...
b) an employee take leave from 3/6/03 to 6/6/03 ( count the duration and the balance of the leave).....
<in my web site exmple>
from date: xx/xx/xx (empty field)
to date : xx/xx/xx (empty field)
duration : <result>
balance : <result>
[submit] <button>
after insert the from date and to date and click submit, the duration and the balance of leave will automatically show