Philippe Bouvet
|
| Posted: 05/14/2003, 6:23 AM |
|
Hy,
I have a form with name, surname and email. The user fills it, and when he submits, i want in the same time get a email and fill the database.
Has some one an idea? mySQL and PHP if possible.
Thanks
|
|
|
 |
Headhunter
|
| Posted: 05/14/2003, 7:44 AM |
|
CC or CCS? Version?
|
|
|
|
LeFrancais Philippe
|
| Posted: 05/14/2003, 8:36 AM |
|
CCS
|
|
|
|
rclayh
|
| Posted: 05/15/2003, 12:09 PM |
|
On the record form that contains the data you are submitting, select the "Before Insert" event in the Events list in the property box. Click the + sign to add custom code. Select "Send Email" from the list. Then click select the values for the from and to and subject and message. You can double click if you need to to actually mess with the code.
|
|
|
|
RonB
|
| Posted: 05/17/2003, 11:03 PM |
|
Bettr use the after insert event because otherwise there might be problems if something goes wrong with the insert. The user would still receive an email while the insrt failed.
Ron
|
|
|
|
rclayh
|
| Posted: 05/18/2003, 11:56 AM |
|
Didn't know if the variables would still be in scope after insert but it's better to email after success than before for sure.
|
|
|
|
