sending mail

[slimjim]

Ok i have this ipn script, now it sends mail to the $payer_email that they use to send payment from paypal, but I can not get it to send email to the email in database. Now if i use $email instead of $payer_email, i get no email. I also do not want it to say it is coming from apache like it does. Any ideas for me here. Now it all works fine, even sending email, but not able to get variables from the last select or something. Going nuts here.

// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('www.paypal.com', 80, $errno, $errstr, 30);

// assign posted variables to local variables
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$amount = $_POST['mc_gross'];
$currency_code = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {
// check the payment_status is Completed
// check that txn_id has not been previously processed
// check that receiver_email is your Primary PayPal email
// check that payment_amount/payment_currency are correct
// process payment
$query = "update slist set sub='$item_number' where id='$id' and uid='$uid'";
mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");	
echo "You have just updated!<BR><BR>";
//Below is what I am doing to send email	
    $query="SELECT id, uid, email, firstname, lastname from slist where id='$id' and uid='uid'";

$Subject = "Test";
$content = "test this out";
mail ("$payer_email", "$Subject", "$content");
}
else if (strcmp ($res, "INVALID") == 0) {
// log for manual investigation
}
}
fclose ($fp);

[vmusic]

Hi,
When I looked at your code, I ddin't see where you're pulling the users or payers email from the database, you never did anything with it.

This code:
//Below is what I am doing to send email

$query="SELECT id, uid, email, firstname, lastname from slist where id='$id' and uid='uid'";

$Subject = "Test";
$content = "test this out";

mail ("$payer_email", "$Subject", "$content");

[/B]Where did you store off the row from your select query?[/B]

After you defined your sql statement where did you 'run' the sql?

Where did you connect to the database, and run your query. You have to do all that to retrive the row back for that person or payor.

For your other question... .there is actually a 'from' parameter in PHP's mail() function
http://us4.php.net/manual/en/ref.mail.php

Hope that helps!!

[slimjim]

Yeah i had to many issues trying to make this thing so i am scrapping the whole thing. Thank you