Auto Reply Email with PHP when MySQL is updated

[Dan K.]

I am trying to build an application using PHP and MySQL that captures
information regarding an individual. Name, address, email etc. I have no
problems getting their information to write into the MySQL database. What I
would like to be able to do is after the individual presses the submit button
on the page, their informatin gets written into the database and an email
message goes automatically back to them thanking them for signing up as well as
sending me an email so I am aware that a new record has been entered into the
database. This is where I am completely lost. I found a helpful post in this
forum that gave me the ability to send an email just to me but not to the
person who signed up. It would be great if in the message body I was able to
show them what they submitted but that is not necessary. I am also building a
section of the site to permit people to update their record as well and would
like the ability to send the same message after someone updated their
information as well. I am building the application using Dreamweaver MX on Mac
OS X and hosting the application on a RedHat Linux machine with PHP Version
4.3.11.

Any help would be greatly appreciated.

Thanks in advance.

Sincerely,
Daniel Krajc

[rickvv1]

I have used this PHP form mailer with great success. And it sounds like it does
everything you are looking to do (except the User Self-Update part of your
queston, but I'll bet you'll be able to figure it out from here)
Download the zip, study the code, and change it to suit your needs.
I hope I'm not off-base by referring yuo to a non-Macromedia solution.
[url]http://www.xentrik.net/php/mailform.php[/url]

Use the DW 'Insert Record' behavior to supplement the mail code.
Good Luck,
rick

[rickvv1]

So, just wondering if you got this going? Did any of my advice work?