Send email after sign up

[Eskimo]

I have a form on my website linked to a MySQL database. The form works perfectly, adding the correct data into the rows. However, I want to add some PHP coding to automatically send an email to the person who signs up. In this email I would prefer several of the details they have supplied in the form to be included. Similar to what you receive when you sign up at certain forums, with your username, password and whatnot.

I have absolutely no idea how to do this, any takers? [img src=\"style_emoticons/[#EMO_DIR#]/huh.gif\" style=\"vertical-align:middle\" emoid=\":huh:\" border=\"0\" alt=\"huh.gif\" /]

[AndyB]

Start by looking at the manual section for php's mail function - [a href=\"http://ca.php.net/manual/en/ref.mail.php\" target=\"_blank\"]http://ca.php.net/manual/en/ref.mail.php[/a]

[Eskimo]

I have managed to get an email send when the user clicks submit. However, I am having trouble adding into the email the autonumber that is generated for each field (the ID number). Since this is not a field the user types in the form I cannot just se a variable.

I think I need to use a query of sorts but I'm not sure which one. Ideas?

[fenway]

Retrieve the LAST_INSERT_ID() from MySQL into a PHP variable, and then make the necessary substitution in your e-mail template.