gevensen Posted November 5, 2009 Share Posted November 5, 2009 omit is an enum deposit_link is an int(11) service_date is a date if I leave off AND `deposit_link` > '0' it works add it it returns zero rows but there should be 5 rows affected what am i doing wrong? UPDATE `sc_income` SET `omit` = '1' WHERE `service_date` < '2009-08-29' AND `deposit_link` > '0' Link to comment https://forums.phpfreaks.com/topic/180426-solved-why-wont-this-query-work-should-be-simple/ Share on other sites More sharing options...
gevensen Posted November 5, 2009 Author Share Posted November 5, 2009 guess i found my own answer UPDATE `sc_income` SET `omit` = '1' WHERE `deposit_link` > 0 AND `service_date` < '2009-08-29' Link to comment https://forums.phpfreaks.com/topic/180426-solved-why-wont-this-query-work-should-be-simple/#findComment-951864 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.