473,322 Members | 1,345 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Simple Email Trigger Question, just am very new to triggers

Hi,

I'm trying to send an email to' sample@sample.com' when a new row on my table contactform_con is inserted. Basically, when a person fills out the contact form (contactform_con) I want one email to go to one person to let them know.

I've tried doing this using both navicat and PHPMyAdmin, but I've had no success.

I've tried using EXEC xp_sendmail, but I'm not even sure if I have that as a stored procedure, or if I do need to.

All I really need is an email going to 'sample@sample.com' that is basically

@subject='clientname_con' has contacted you!
@recipient='sample@sample.com'
@message='quesiton_con'

when table contactform_con has a new row inserted.

Please help,
I've been online for hours, because I felt this was too simple of a question to not be able to figure out, but I guess I'm even more simple than the question.

emily
Sep 3 '10 #1
3 1623
JKing
1,206 Expert 1GB
xp_sendmail is a part of MS SQL.

MySQL as far as I know has no support for sending emails.
Sep 3 '10 #2
So is there no way to alert sample@sample.com when a row has been inserted into contactform_con?
Sep 3 '10 #3
JKing
1,206 Expert 1GB
If you are inserting the rows through a php script you would be able to modify it to send emails upon a successful insert.
Sep 3 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Alejandro | last post by:
Hi! I have no experience at all using triggers, and I don't even know very well SQL server. I hope someone can help me with the folling: I need to know if it is possible to implement a trigger that...
1
by: decoy | last post by:
Hi everyone, I have an Oracle trigger that writes any updates to a specified table to a file on the filesystem (using pl/sql). How can this be done using triggers in mySQL 5+? Thanks in...
2
by: Jean-Christian Imbeault | last post by:
Following up on the discussion yesterday on how to prevent the generation on log error messages when someone tries to insert a duplicate primary key record and Nigel Andrew's suggestion of using a...
4
by: Jules Alberts | last post by:
Hello everyone, I'm working on a tiny trigger function that needs to ensure that all values entered in a field are lowercase'd. I can't use pl/pgsql because I have a dozen different columns...
2
by: Jack | last post by:
We are have a question about the no cascade option on before triggers. The description stays that no other triggers will be fired by the changes of a before trigger. One of our developers is...
1
by: Terry Lee Tucker | last post by:
Hi, I have a simple question. I have been looking at the HTML docs for Postgres version: PostgreSQL 7.2.3-RH on i686-pc-linux-gnu, compiled by GCC 2.96. I need to know if it is necessary to...
9
by: arnuld | last post by:
hello folks, i have a simple one line question. i am planniing to 1st learn Assembly & then C++: are there any jobs that i can get by learning C++? -- if yes, what type of jobs are...
30
by: galiorenye | last post by:
Hi, Given this code: A** ppA = new A*; A *pA = NULL; for(int i = 0; i < 10; ++i) { pA = ppA; //do something with pA
1
by: Bart Van der Donck | last post by:
Hello, In my application, I'm having a directory with a bunch of .eml files. It was my intention to read out with PHP this directory, make a list of it and show them as .eml links in the...
4
by: karen.homersham | last post by:
Just working through Apress Pro ASP NET.2.0.E Commerce in C Sharp. I am having problems compiling the following: using System; using System.Collections.Generic; using System.Text; namespace...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.