send mail

[amit]

please let me know how to send mail using php to a person whose email address is stored in the table of my database?

[PHPThorsten]

Where's your problem?

Connect to your database, and select the email Adress.

then use this result as recipient for the mail() function.

This would look like

$email = $db_conn->query("SELECT email FROM people WHERE id = '1'");

mail($email, "Subject", "Message");

[Floodboy]

$sql=mysql_query("SELECT email FROM table");
$rows=mysql_fetch_array($sql);
extract($rows);
mail($email, "topic", "message","From: Me <[e-mail]>");