form completed, now send email....

[toddmarx]

Ok, I think this one might be a tuffie. Here is the jest of it.

I have a feedback form on a site. The form submits the feedback to the database. This all works fine (thanks to the help of all you that helped me out on this one). Now what I want to happen is that once feedback has been posted to the database via the website form, I need an email sent to an admin to let her know that feedback has been submitted and she needs to go check it out. The info that I would like in that email will include the field id.

So in other words the email would look something like this:

Greetings Admin,

A user has posted feedback to our website. Please refer to (email id field)

Thank you,
Systems

I know that this will probably not be an easy one. Not only do I need it to send an email notice, but I need it to include the id of the message that was posted.

I have searched the forums, and other sources and all I can find is how to send the feedback via email or via form, but not how to send the info to the db, and then send an alert via email.

Thanks,
Dazed and confused 😕

[yelvington]

After performing the insert,

$adminaddr="[e-mail]";

$id = mysql_insert_id();

mail($adminaddr, "Greetings Admin,
A user has posted feedback to our website. Please refer to $id.
Thank you,
Systems ");

[yelvington]

Oops, I neglected to set the subject in the call for mail().

$adminaddr="[e-mail]";

$id = mysql_insert_id();

mail($adminaddr, 'Feedback posted',
"Greetings Admin,
A user has posted feedback to our website. Please refer to $id.
Thank you,
Systems ");

[toddmarx]

oh yea! That was too easy! Thank you so much!!! 😃

[toddmarx]

I guess I was expecting some long drawn out script. I envisioned hours of me behind my computers cursing obsenities, banging on my keyboard, and pulling my hair out ever increasing my bald spot!

Thanks again!