I need a page which will allow me to edit and delete time punches (employee time tracking)
I have two tables, one contains user data (users) one contains time data (times).
users table contains:
eid (unique employee number)
pstatus (punch status 1=IN, 0=Out)
times table contains:
pid - punch ID - auto-increasing, unique to every punch.
pstatus - Punch status: 0 = punching out, 1 = punching in
time - the date and time of the punch in timestamp format (0000-00-00 00:00:00)
eid - employee ID, identifies the employee