mail mysql data

[klimi]

I have created a php form to add data in mysql It works fine

the same time I would like to send an email with the data to the user

Could you help
Attached you can find the php form

Thanks alot
I have to mention that I am absolute begginner in php and mysql

[TF_TheMoon]

Why have you posted this three time?

See this post of yours http://phpbuilder.com/board/showthread.php?t=10320421&highlight=mysql+data+mail

[chinrub]

if you wanna send something from the result of your query
something like this in your code might help
I'm pretty new to this too I can't offer much help

Your basically gonna need to use the mail function.
This will send a plain text email, unless you specify your using mime in the $headers.
Something like

$headers  = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";

while ($row = mysql_fetch_array($recordset1)) 
{
   //I'm assuming you might have a row of emails addresses you want to send to here
   $email = $row_recordset1['email'];
   $someOtherVariablesYouWannaInclude = $row_recordset1['one of your tables fields'];
   mail("$email", stripslashes($_POST[subject]), ($_POST[message]), $someOtherVariablesYouWannaInclude $headers);
   print "newsletter sent to: $email<br>";
}

Hope it's good, first time post offering help to someone 😛

[Blulagoon]

Look up the mail() function on www.php.net

I'm sure you'll get the idea. Just slot it in after your script confirms that you have successfully inserted the data into the database.

Blu