Mail function

[Breekan]

Can anyone please explain to me why this is not working? (I shall refer to my email as [e-mail])

mail($tempemail, "Password Recovery", $message, "From: [e-mail]");

$tempemail is [e-mail], $message is "This is a test to see if password recovery will work".

For some reason I just can't get it to send to my mail account

[rapmonkey]

Try this, it should work:

$headers = "From: " . $name . "<" . $email . ">\r\n";
mail($recipient, $subject, $message, $headers);

where: $recipient is the email to send to, $subject is the subject, $message is the message (body) of the email, $name is the name of the sender, and $email is the email address ([e-mail]).... Let me know if it works 😃

[Breekan]

Err wait, let's pretend my email is [e-mail] and I want to send to [e-mail]

How would I set it up precisely? I may be screwing up on quotes somewhere

[rapmonkey]

You would just change a couple things:

$headers = "From: " . $name . "<" . $email . ">\r\n";
mail($recipient, $subject, $message, $headers);

all the variables are the same but: $name is your name, $email is YOUR email, and $recipient is where you want the email to be sent.

[Breekan]

<?php
$db_name = "breekan";
$table_name = "users";
$name = "Breekan";
$myemail = "[e-mail]";
$subject = "Password Recovery";

$tempemail = mysql_fetch_row(mysql_query("select email from $table_name where user=\"$user\""));
$temppass = mysql_fetch_row(mysql_query("select pass from $table_name where user=\"$user\""));
$message = "This is Breekan with the information you requested. User: $user Password: $temppass[0]";
$headers = "From: " . $name . "<" . $myemail . ">\r\n";

mail($tempemail, $subject, $message, $headers);

?>

correct?

[rapmonkey]

looks ok to me..... check it out 😉

[Breekan]

If that happens to be correct in your eyes; for some reason it does not work. My email account is getting nothing

[Breekan]

Ack sorry for the double post

[rapmonkey]

I know for a fact that the mail() funtion I gave you works because I have a script I made that uses it..... So I am guessing your problem is where you are pulling out your information of the MySQL database.

[Breekan]

How can I check that I am pulling out the correct values?

[rapmonkey]

I dont know of any way, just keep trying 🙁

[hometoast]

this probably isnt the problem, but i may simplify things..
1st do 1 query: select email,pass from $table_name where user=\"$user\"";

2nd: from php.net: Subsequent call to mysql_fetch_row() would return the next row in the result set, or FALSE if there are no more rows.

so so $something = mysql_fetch_row(mysql_query(...));
then $something[0] and $something[1] or $something['email'] and $something['pass'] are the data you want.

Hope that makes sense to you.

-dan

$tempemail = mysql_fetch_row(mysql_query("select email from $table_name where user=\"$user\""));
$temppass = mysql_fetch_row(mysql_query("select pass from $table_name where user=\"$user\""));
$message = "This is Breekan with the information you requested. User: $user Password: $temppass[0]";
$headers = "From: " . $name . "<" . $myemail . ">\r\n";

correct?