in reply to Sending Custom Mass Mail - Fastest Way Possible

Side comment. The queries use dynamic SQL, which can be bad for security and performance. $connect{database} is particularly bad, because any query could be run as long as it ends in a semi-colon. No breakout required. Though, there may be no way to address that issue directly and still be convenient. Are you sure you want the database to be a variable?

  • Comment on Re: Sending Custom Mass Mail - Fastest Way Possible

Replies are listed 'Best First'.
Re^2: Sending Custom Mass Mail - Fastest Way Possible
by edimusrex (Monk) on May 29, 2015 at 16:52 UTC
    Not too overly concerned with it as the script is run locally and the database user only has access from the localhost. Any recommendations on improving my code is of course welcomed. I have learned all this on my own and on the fly so I really do appreciate any help offered.

      Just be wary because although it is "not required here", scripts often go off in unexpected ways, and fixing it then may be impractical. Further, fixing the small scripts is excellent practice for the larger ones to come. :)