Help! How do i mail a value from a mysql databse?
| From: | Raymond | Date: | Tue, 13 Nov 2001 17:56:16 +0000 |
| Subject: | Help! How do i mail a value from a mysql databse? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-74473@lists.php.net to get a copy of this message | ||
Hi!
I'm trying to send a mail with password to the new user of my website, but
......... Does anyone know how to put the variable inside my mail?
I have tried this:
---------------------->
else {
// sende kundeopplysninger til databasen
$db = mysql_connect("localhost", "root");
mysql_select_db("subway",$db);
$sql = "INSERT INTO nettkunder
(fornavn,etternavn,firma,adresse,postnr,sted,telefon,epost) VALUES
('$fornavn','$etternavn','$firma','$adresse','$postnr','$sted','$telefon','$
epost')";
$result = mysql_query($sql);
echo "Velkommen som kunde hos Subway.\n";
}
$db = mysql_connect("localhost", "root");
mysql_select_db("subway",$db);
$id = mysql_query("GET id FROM nettkunder WHERE epost = '$epost'",$db);
mail("$epost", "Velkommen som kunde hos Subway", "Her har du ditt passord:
$myrow["id"] \n God appetitt! Hilsen Subway");
Regards Raymond