If update send mail??

[nackgr]

Hallo guys!!

 

I have this script

 

<?php
$name = mysql_real_escape_string($_REQUEST['name']);
$link = mysql_real_escape_string($_REQUEST['link']); 
$filename = mysql_real_escape_string($_REQUEST['filename']);
if(empty($name) || empty($link) || empty($filename))exit; 

mysql_connect('localhost','root','');
@mysql_select_db('1') or die( "Unable to select database");

if (!mysql_query("INSERT INTO `1`.`files` (`name`,`link`,`filename`) VALUES ('$name','$link','$filename');"))
  {
  echo 'Fail!';
  exit;
  }
  else
  {
  echo "Succesfuly added!";  
  }
mysql_close();

?>

 

works fine when they send me link to

 

mydomain.com/script.php?name=1&link=2&filename=3

 

and database updates fine , but the idea is

 

That each name  is owned by a group and every group has a different email adresse , how can automatically

send email  at the time someone send a link to my adress  (mydomain.com/script.php?name=1&link=2&filename=3)

 

with few words i want to notify the owner of the group (name) for the  link and filename values

 

 

Thats the story

Thanks!!!