: Does any one have a suggestion on running a daily / weekly e-mail
: notification based on results from a MySQL query?
In your cron file do something like:
echo "select * from table" | mysql [options] db | mail
[EMAIL PROTECTED]
If it's a more complex query:
cat ~/query.sql | mysql [options] db | mail [EMAIL PROTECTED]
It still doesn't solve your problem perfectly, since you can't set email
addresses
dynamicly in that manner. I think you need to write a litle more than an SQl
query
or even a cron task.
Go with either Perl or PHP. For sending email you can use either "mail" or
"sendmail".
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
