[UPHPU] mysql date calculation bug

[Jim Anderson]

Ben Reece wrote:
>
> Jim Anderson wrote:
>> Yeah, further digging on the mysql developers site gave me this reply 
>> as well. I guess I will need to flesh something out that will handle 
>> that scenario because you are right, it does kind-of make sense.
>>
>>
>> thnx,
>> -jim
>
> So what result are you trying to achieve with this query, if what 
> MySQL provides doesn't meet your needs?
>
> Ben

I have a client base that certain emails must be sent out a various days 
befor and after 6 months from the date that they sign up for service. 
With that in mind, I created a system that handles the requirements 
however, I found this issue this morning. This issue results in an email 
getting sent [worst case scenario of] 4x in a row [1 a day for 4 days.] 
Best case [error] scenario is only 2x, but still bad. Don't want to 
flood one's inbox with frivolity.

My fix, considering this snag, is to check the client logs and check to 
see is the email was sent within the last 4 days and, if so, don't send 
again.

I hate this fix as it is clunky and not at all pretty, but I can't think 
of another way to do it. If anyone has any suggestions, please feel free 
to pipe in.

Thanks for asking Ben,
-jim