where clause in pdo

[ramiwahdan]

Hi, 

i am trying to add where clause to the code below:

$res = $conn->query("SELECT oracleid
                         , name 
                         , des 
                         , clockingindate   as clockin
                         , clockingoutdate  as clockout
                         , timediff(clockingoutdate, clockingindate) as duration
                         , total
                    FROM attendance_records
                         JOIN (
                                SELECT oracleid
                                     , sec_to_time(sum(timestampdiff(SECOND, clockingindate, clockingoutdate))) as total
                                FROM attendance_records
                                GROUP BY oracleid
                              ) tots USING (oracleid)
                    ORDER BY oracleid, clockingindate
                    ");

i need to add where clause as following:

From attendance_records where isdone = -1
Join...

how to achieve that

[ginerjm]

Why don't you do some good old experimentation and see where it works?  Or you could look it up in a manual.   

[ramiwahdan]

found it

Edited March 16, 2020 by ramiwahdan
finish