[PHP] Help! How do i mail a value from a mysql databse?

[Raymond]

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









-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]