Issue in displaying 0000-00-00 00:00:00 or IsNull values

[newphpcoder]

Hi,

I notice that in my query:

 

$result = mysql_query("INSERT INTO payroll.reg_att(EMP_NO, LOGIN, LOGOUT, TotalHours) 
SELECT DISTINCT a.EMP_NO, a.LOGIN, a.LOGOUT, TIMEDIFF(a.LOGOUT, a.LOGIN)  FROM payroll.date_upload d, attendance.employee_attendance a JOIN hris.employment em ON (a.EMP_NO = em.EMP_NO AND em.STATUS = 'Reg Operatives') WHERE DATE(LOGOUT) BETWEEN '$FROM_DATE' AND '$TO_DATE' AND d.EMP_STATUS = 'Reg Operatives' OR ISNULL(LOGIN) OR ISNULL(LOGOUT)")  
or die(mysql_error());

 

it did not insert data where LOGOUT is 0000-00-00 00:00:00

 

i attach my sample file

 

Thank you

18169_.doc

[fenway]

I don't need to see a DOC -- but your WHERE clause doesn't check for LOGOUT = 0.