From: Date: September 6 2002 5:00pm
Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
List-Archive: http://lists.mysql.com/mysql/118953
Message-Id: <00ae01c255b6$2db63580$2100a8c0@EXPERIENCE.local>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit


Michael T. Babcock wrote:

>May I rephrase your comment?
>
>"I need to send E-mails to people from MySQL data".
>
>I recommend just doing a SELECT on the data in question and generating
>the E-mails from PERL or PHP or whatever other language you are using.




No you may not ;-)
*joke*

It needs to be run automatically without user intervention [cronjob] so
the PERL [not an option as I've never used it]  or PHP would have to be
of the CGI variety [if that's what you call the standalone version, not
the API for the web server].

But it is an option and I'll consider.

I'll probably try the suggestion by Ralf Narozny first.
It seems to be exactly what I want, plus... It's relatively simple :-)

I'll also have to read up on those UDF's. Sounds interesting.


Cheers everyone.

Regards

**************************************************************
*       K   e   i   t   h           B   u   r   k   e        *
**************************************************************
* Experience IT Ltd       * Phone : +353 1 xxx xxxx          *
* Unit G6                 * GSM   : +353 86 xxx xxxx         *
* Riverview Business Park * Email : kburke@stripped     *
* New Nangor Road         * WWW   : http://www.experience.ie *
* Dublin 12               *                                  *
* Ireland                 *                                  *
**************************************************************