Issue in saving 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


Thank you

[WyCnet]

Hi, to begin, can you represent your thought out logical precedences for the "ands" and "ors" in the Query using parentheses?

[newphpcoder]

Hi, to begin, can you represent your thought out logical precedences for the "ands" and "ors" in the Query using parentheses?

What?

Use parenthesis in OR and And?

Thank you

[newphpcoder]

Now, I realize why the LOGOUT = 0000-00-00 00:00:00 was not save because of this condition:

$FROM_DATE = 2012-03-01
$TO_DATE = 2012-03-15
WHERE DATE(LOGOUT) BETWEEN '$FROM_DATE' AND '$TO_DATE'

now how can I get even the DATE(LOGOUT) = 0000-00-00

Thank you so much