Sending an email when new record added

[cj_quench]

Hi folks,

I have used the PHP Site Assistant to create a few online forms that dump data into a FM database. Works very well and have done this quite a few times.

I would like to be able to have an email automatically sent any time someone fills out one of these forms. I am using old PHP code I had lying around to send an email using the ob_get_contents() function to load the data into the message of the email. (Used to do this all the time to send emails of raw html form data.) Got this working, but the way that FMview.php works, the field names get translated into numbers instead of something even remotely human readable, so the emails are essentially useless.

Has anyone done what I am trying to do or have an easy solution?

My company has not yet upgraded to Server 10. In v10 is it possible to write a FM script that sends an SMTP email through FM Server that is triggered by PHP that would allow me to accomplish what I am trying to do?

Any thoughts or help would be appreciated.

[printdrive]

bump... any suggestion? please... thank u in advance :

[cj_quench]

Thanks for the bump, printdrive.

All I can figure to do is to hardcode PHP that converts the numeric field identifier into its corresponding field name, but this seems silly, as I would like to use this email code for multiple projects.

Is there a function in fmview.php that returns the name of the field given the field id number?