[fui_koh]

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 …

[BdSBB]

$duration = floor(($from_date - $to_date) / 86400);

I don't quite understand the balance part.

[fui_koh]

ok nvm .....
its enough alteady....
anywhere thank you