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
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
