E-mail stuff

[Anon]

I know it has been asked before, by probably hoards of people, but I am going to ask again, because I can't find an answer.
Can anyone give me a site where I can access an Access DB and has a good tutorial on what I can do and how to do it while I am in that ODBC connection with PHP? It would be extremely helpful for me. I basically need somewhere that I can go for a worthwhile SIMPLE, tutorial that(by the way, I can wait on the first 2, but I really need a way to do the 3rd one, and a second actioin would be perfect, but html only allows one action.
1)connects to a DB and accesses the data fields for display in a pretty table, based on the current date.
2)sends the results of a form into a DB.
3)E-mail, from whatever, but VERY preferably so the user does not have to have anything opened from their side... to me notifying me that a new entry has been placed in the DB.

[mithril]

PHP-Access Tutorial:

http://www.phpbuilder.com/columns/siddarth20000228.php3

Sending insert notications:

function sendMail() {

global $SERVER_NAME,$SERVER_SOFTWARE;

$date = date("Y-m-d");
$time = date("H:i:s");

$to = "[e-mail]";

$subject= "New Record Inserted to Access DB";

$body: = "On $date at $time, a user successfully inserted a new record into the M$ Access backend";

$x_headers = "From: \"Automated Record Insert Notifer at
$SERVER_NAME\"\nReply-To: \"\"\nX-Mailer: $SERVER_NAME via $SERVER_SOFTWARE";

@mail("$to", "$subject", "$body", "$x_headers");
}

Simply write your db functions to call this function if the record insert/update succeeded. You need to make sure that you have specified your sendmail path (*Nix) or external smtp server address (Win32) in order for the mail to send. HTH,

Cheers,

Geoff A. Virgo