I have a problem to split data from attendance machine. The data source after export from it like this:
id name att 1 John 01/04/2015 7:59:00 1 John 01/04/2015 17:44:00 1 John 02/04/2015 7:50:00 1 John 02/04/2015 18:14
Where record (in and out) from fingerprint time save in one column. And I want to split the data to be like this:
id name in out 1 John 01/04/2015 7:59:00 01/04/2015 17:44:00 1 John 02/04/2015 7:50:00 02/04/2015 18:14:00
How to split those record into 2 column in MySQL or PHP (maybe)? Thank you.