Attendence System

[elliott0184]

Ok so thought I would use the same thread even though I am much further on. Now I am looking at the clocking out section. I have managed to get the system to get them to input their staff id twice. it then goes to check the server. if it finds the right code in one of the MYSQL tables it returns saying clocked it. It then adds a row to a different table with the date in one column, the "time in" in another and their name in the last. 

How do I get it to check if they are already clocked in that day and if they are, clock them out by adding a time into the clock out column.

Any help would be great thanks