form multiple actions?, sending a form to mysql table, and mail

beachnut

Here is the code I'm trying to send to mysql and to mail back a copy to me.

The mysql part works. How do I mail it to me and redirect to a thank you page??

Any help is appreciated.

Thanks

Beachnut

<?php

include "../config.php"; //the file is outside this directory
// Success messages

$sql_txt = "insert into names (fname, email, upass) VALUES('$fname','$email','$upass')";
mysql_query($sql_txt) or die ($err_query);

echo "

<tr>
<td><B><font size=2><font color=RED></font>Full Name:</font></B></td>
<td align=left><input type=\"text\" name=\"fname\" size=\"25\"></td>
</tr>
<tr>
<td><B><font style=verdana><font size=2><font color=RED></font>Email:</B></font></font></td>
<td align=left><input type=\"text\" name=\"email\" size=\"25\"></td>
</tr>
<tr>
<td><B><font size=2><font color=RED></font>Over 18? Yes or No!:</font></font></B></td>
<td align=left><input type=\"text\" name=\"age\" size=\"3\"></td>
</tr>
<tr>
<td><B><font size=2><font color=RED></font>Passw'd you want (5-Max 8):</font></B></td>
<td align=left><input type=\"text\" name=\"upass\" size=\"8\"></td>

</tr>
<tr>
<td colSpan=2 align=center><INPUT type=\"Submit\" name=\"BtnSubmit\" value=\"Create account\"></td>
</tr>
</font>
</table>
</TD>
</TR>
</TABLE>
</CENTER>
</FORM>";
?>

rachel2004

For the ability to mail something, start by looking at the mail() function:

http://us3.php.net/manual/en/function.mail.php

The examples on that page are pretty useful and the user comments help as well.

As for redirecting a user to a thank you page, use the header() function.

Since you'll already be at www.php.net looking at the mail function, you can type in "header" yourself to find the portion of the manual that explains it. ;-)