Updaiting MySql and send ing the form via email

[Anon]

How can I update my sql database and email the data in the form?

Thanks

[Anon]

Hi! You've to do the next:

<?php

mysql_connect("server", "user", "password");
mysql_select_db("dbtouse");

$sql = "HERE YOU HAVE TO INTRODUCE THE SQL STATMENT THAT YOU NEED TO UPDATE YOUR DATABASE";

mysql_query($sql);

$mail_data = "HERE CREATE A VARIABLE IN WHICH YOU STORE THE FORM DATA";

mail("To:", "Subject;", $mail_data);
?>

Basically, this code do what you need. Off course, you have to modify for your convenience. Anyway, I Hope This Help

Bye

inK

PS: excuse my english

[Anon]

Could you tell me what would come between the "" below? How would it look? Thanks!

$mail_data = "HERE CREATE A VARIABLE IN WHICH YOU STORE THE FORM DATA";

[Anon]

Hi!!! Well... the $amil_data variable it\'ll look like.. the content of your mail!!!

Example:
You want your mail to show this information
-=[Begin Mail]=-
Name: inKel
email: [e-mail]
-=[End Mail]=-

Your $mail_data should look like this:

$mail_data = \"Name: inKel\n\";
$mail_data .= \"email: [e-mail]\";

Easy, ins\'t?? =)

Anyway, feel free to ask. See ya

inK

[Anon]

Hi Should it look like this?

<?php
$sql = "INSERT INTO Quotes (NAME, ORGANIZATION, EMAIL, PHONE, SI) VALUES
('$Name', '$Organization', '$Email', '$Phone', '$Si')";

//create connection
$connection = mysql_connect("localhost","thecover","156969") or die ("Couldn't connect to server.");

//select database
$db = mysql_select_db("Wafers", $connection) or die ("Couldn't execute database query.");

//execute SQL query and get result
$sql_result = mysql_query($sql,$connection) or die ("Couldn't execute sql query.");

//Mailing Data

mail("[e-mail], [e-mail]", "MailingList", $sql);

if (!sql_result) {
	echo "<P>Couldn't add record!";
} else {

echo "	

<table cellspacing=5 cellpadding=5>
<tr>
<td valign=top><strong>Name:</strong></td>
<td valign=top>$Name</td>
</tr>
<tr>
<td valign=top><strong>Organization:</strong></td>
<td valign=top>$Organization</td>
</tr>
<tr>
<td valign=top><strong>Email:</strong></td>
<td valign=top>$Email</td>
</tr>
<tr>
<td valign=top><strong>Phone:</strong></td>
<td valign=top>$Phone</td>
</tr>
<tr>	
<td valign=top><strong>Si:</strong></td>
<td valign=top>$Si</td>
</tr>
</table>
</form>
";	
}

-=[Begin Mail]=- 
Name: Chris
email: [e-mail] 
-=[End Mail]=- 
$mail_data = \"Name: Chris\\n\"; 
$mail_data .= \"email: [e-mail]\"; 

?>