Mike wrote:
I'm making a library website where users can store preferences about the
types of books/cds/etc... they like (e.g. romance, rock, cooking, etc....).
Once a month the list of 'New Releases' is updated. Currently there is a New
Release box which shows releases based on the users preferences.
This type of functionality is the responsibility of your program, not the MySQL backend. MS SQL Server may offer this option, but MySQL does not and there are thousands of programs and libraries you can use to do this very simply.
Please consider going to freshmeat.net or whatever your favorite "search for programs I want" search engine is and search for "Send E-mail".
If you were using PERL, there are several libraries available. In PHP, its built-in. With C or C++ I'm sure you could find one but I wrote my own, and in a *nix shell script, you can do something like:
#!/bin/sh
cat $message | sendmail [EMAIL PROTECTED]
Look up how E-mail messages are formatted (its text; do a view source on this message, for an example) and you're probably home-free.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
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
