update database/send email

[lisa3711]

I have two pages.
One user fills in a form with different information. In one field, they choose a technician.

When they click submit, their submission is displayed and written to a mysql database. This works fine.

I want to add a functionality now where depending on the tech the user chooses on page one, the tech is sent an email saying "You have a message in the database for you", at the same time the database is updated with the information.

Thanks, you guys are great!

[bastien]

$message=$POST['message'];
$tech=$POST['tech'];

//insert query here

$result=mysql_query($sql);

if (!$result){
//echo insert failed
}else{
//echo insert successful
//depending on how you set things up you may need to query a db table
//to pull out the tech' email address
//then

mail ($to,"You have a new message", $message);

hth