Send email after registry

[Russia]

Hello I currently have this php script that when a person registers they get added to a database.

 

Code:

<?php
$date2 = date("F j Y");
$ip = $_SERVER['REMOTE_ADDR'];

require("inc/config.php");

$sql="INSERT INTO persons (Username, Password, Ip, AddedDate)
VALUES('$_POST[username]','$_POST[Password]','$ip','$date2')";
if (!mysql_query($sql))
{
die('Error: ' . mysql_error());
}
echo "Thank You for registering.";
mysql_close()
?> 

 

What I would like to add is send email to admin when a user registers.

 

The Admin email address is in the Table named: members

The column name is: email

and the id of the admin is: 1

 

Basicly the 'Send To:' email address I want to be sent to the email address that the admin has in the mysql database and fetch it.

 

Anyone know how to add it?

[mikesta707]

select email from members where id=1...

[mike12255]

so you want to get the admins email from a database and send an email to it?

[Russia]

Yes mate. I hope someone can post a snippet and help me out greatly.

 

I have no idea how to.

[mikesta707]

I gave you the query to do. You obviously know how to do queries from your original code...

[Russia]

I really do not know how to honestly.

 

Can you help me integrate it into this script?

 

<?php
$to = "you@yoursite.com";
$subject = "New Registred User";
$from = $_REQUEST['email'] ;
$message = "A new user has signed up and has been added to the database";
$headers = "From: $email";
$sent = mail($to, $subject, $message, $headers) ;
?> 

 

I want the '$to' email address to be fetched from the database.

[Russia]

Bump.

[Russia]

Another Bump.