how to filter in sql

Posted by user3634746 on Stack Overflow See other posts from Stack Overflow or by user3634746
Published on 2014-06-12T03:20:49Z Indexed on 2014/06/12 3:24 UTC
Read the original article Hit count: 67

Filed under:
|
|

good day i have a database containing time in and time out and i want to filter all the record of the employees time in and time out. here is my sample db using php and mysql

PersonalId   LogCount        LogDate             LogType  LogKind  
    2           1      2014-04-09 12:42:24           0      0
    2           1      2014-04-10 12:43:53           1      0
    2           1      2014-04-11 02:17:39           0      0
    2           2      2014-04-09 12:42:48           1      0
    3           2      2014-04-10 12:44:14           0      0
    3           2      2014-04-11 02:48:54           1      0
    3           3      2014-04-09 12:43:23           0      0
    3           3      2014-04-09 12:43:23           1      0 

0 in log type is =login 1 in log type is =login

this will be the format

emp id        IN                        OUT              HOURS
   2      6/2/2014  8:15         6/2/2014 17:00      7.25
   2      6/2/2014  8:15         6/2/2014 17:00      7.25

thanks for your help

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql