defcon2000 Posted December 13, 2005 Share Posted December 13, 2005 Hello, Pls tell me what is wrong with my statement: UPDATE reminder set reminderdate = (IF (status = 'Open' and reminded = 'Y' and autoclose = 'Y' and recur = 'Y', ADDDATE(reminderdate, INTERVAL occurence occurencetype), reminderdate)) occurencetype can be "DAY", "MONTH" or "YEAR" and stored as a VARCHAR. occurenace can be any value such as 1, 2, 5, 12, 10, etc ... and is an INT. Thanks for your help. Rgds, Link to comment https://forums.phpfreaks.com/topic/3041-what-is-wrong-with-this-help-please/ Share on other sites More sharing options...
fenway Posted December 24, 2005 Share Posted December 24, 2005 The date function is called DATE_ADD(), not ADDDATE() -- this should resolve your syntax error, assuming everything else is OK. Hope that helps. Link to comment https://forums.phpfreaks.com/topic/3041-what-is-wrong-with-this-help-please/#findComment-10366 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.