how to set IN and OUT

Question

how to set Which is Intime and which is outtime from fingerprint device I have 2 finger print device in that 2 finger print device im punching intime and outtime Device 1 ==>intime and outtime Device 2 ==>intime and outtime im storing both 2 devices intime and outtime a table intime outtime 04-01-17 08:12:45 04-01-17 18:12:45 04-02-17 08:12:45 04-02-17 18:12:45 04-03-17 08:12:45 04-03-17 18:12:45 04-04-17 08:12:45 04-04-17 18:12:45 how to find which is intime and which is outtime from that record

siva nathan · Answer

for example i have 2 device device 1==>only im punching intime device2==>only im punching outtime like below table employeeid attendencedate 1 04-01-17 08:12:54 2 04-01-17 08:12:54 2 04-01-17 18:12:54 3 04-01-17 08:12:54 see that above table employyeid 1 punching only intime from device 1 not punching outtime in outdevice2so im selecting intime as outtime like below employyeid logintime logouttime status 1 04-01-17 08:12:54 04-01-17 08:12:54 IN 2 04-01-17 08:12:54 04-01-17 18:12:54 IN & OUT 3 04-01-17 08:12:54 04-01-17 08:12:54 IN same way how to find IN and OUT from 2 devicethat two device punching intime and outtime

Sameer Shaik · Answer

please make your question understandable. whats your database design? dont you have any unique Id(Say EmployeeId/StudentId) to track which record belongs to whom ?

Amit Gupta · Answer

As mentioned in your question 'im storing both 2 devices intime and outtime a table' Then whats the problem?

intime	outtime
04-01-17 08:12:45	04-01-17 18:12:45
04-02-17 08:12:45	04-02-17 18:12:45
04-03-17 08:12:45	04-03-17 18:12:45
04-04-17 08:12:45	04-04-17 18:12:45