Eskimo Posted May 27, 2006 Share Posted May 27, 2006 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\" /] Quote Link to comment Share on other sites More sharing options...
AndyB Posted May 27, 2006 Share Posted May 27, 2006 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] Quote Link to comment Share on other sites More sharing options...
Eskimo Posted May 28, 2006 Author Share Posted May 28, 2006 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? Quote Link to comment Share on other sites More sharing options...
fenway Posted May 28, 2006 Share Posted May 28, 2006 Retrieve the LAST_INSERT_ID() from MySQL into a PHP variable, and then make the necessary substitution in your e-mail template. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.