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, Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.