2 things - email recordset in PHP and insert record on click

[Guest]

I have two questions.

1.  I have an apply now button that I want a user to click.  When they click I want it to send the recordset for that page to an email user.  How do I go about setting this up?

2.  When that same button is clicked, I want that recordset to be inserted into a database.

I am guessing I need some function that is called when the apply button is clicked.  The recordset on the apply button will have an email address that is a variabled called contact.

Thanks.

[DwFAQ]

Use insert record server behavior and append an email script to it which is easily found by googling.

[Guest]

Perhaps I wasnt clear on button.  It is a hyperlink for a persons email.  There is no form on the page.  There is a recordset showing all jobs that are approved and a link that says apply now.  When the user clicks apply now, I want part of that user information emailed to the contact in the mailto: reference.

[Guest]

Try to create form to wrap the "Apply Now" button. In form properties, in Action field if u have any redirect page after user clicks just choose the page here. For the button, assume the name is "submit". Then in code, add like this

if (isset($_POST['submit'])) {

...

do the mail function

...

}

[Guest]

I did a form in the field for apply now. It was submited to $_Server[PHP_Self] and it does send my email.  The problem is, it sends an email to my entire recordset listed.  I have 6 records on that page and each person gets an email.  I have changed the form name to be the recordset job name thinking that would solve it but no dice.  I need that apply button to send to only the record it is associated with.  Any advice?