Proble with update query
Posted: Tue Jun 26, 2007 5:40 am
Hi
I am trying to update time in same row, but it's not updating negative time properly
can anyone tell me solution of this query?
mysql_query("update daily_timerecord set FLEX_BALANCE=ADDTIME(FLEX_BALANCE,SEC_TO_TIME($total)) where EMPLOYEE_ID=$id and UPDATE_DATE > '$date' and UPDATE_DATE <= CURDATE()")
in this query FLEX_BALANCE may have "-01:00:00" value but this query runs properly in phpmyadmin but not running through php code...
Thanks
I am trying to update time in same row, but it's not updating negative time properly
can anyone tell me solution of this query?
mysql_query("update daily_timerecord set FLEX_BALANCE=ADDTIME(FLEX_BALANCE,SEC_TO_TIME($total)) where EMPLOYEE_ID=$id and UPDATE_DATE > '$date' and UPDATE_DATE <= CURDATE()")
in this query FLEX_BALANCE may have "-01:00:00" value but this query runs properly in phpmyadmin but not running through php code...
Thanks