shiyukoolest

Hey thanks for your reply but I get these data in the Database from the Biometric reader and the raw data is in this format only. So atleast i need to read these rows from the table and bifurcate them into In / Out

yes sure. I am developing an Attendance Management System. I have the records in the database in this Format. Emp No Date/Time 1 2/6/2007 12:53 1 2/6/2007 14:20 1 2/6/2007 14:54 1 2/6/2007 19:58 1 2/6/2007 20:09 1 2/9/2007 8:32 1 2/9/2007 20:49 1 2/10/2007 8:17 I need to develop an Php MySql query in such a way that when it reads the record from the database, When if for the date 2/6/2007 emp no 1, First record is considered as In time and the second record for the same date is considered as Out time. Hope you got the question this time. Thank you very much

Need My Sql Php query in which if for say date 1/1/09 emp no 1 first record is fetched from database it should be counted as In and second record for same date should be Out. and time Duration between In and Out needs to be calculated. Thanks a lot