send email

[jamal_dakak]

Hi,

Please can some one help me with this:
I have to send an email to the seller asking him to renew his products. The way I've done it. I send an email for each product to renew.
This is template email(EMAIL_RENEW_SELLER):

---

                         Renew your Products

                          [url]http://www.site.com[/url]

---

Dear &NAME&,

There is some products they must be renewed every 14 days to ensure that
they are still available for sale :

Product: &PRODUCT&

Please click on the link below to renew your products:

http://site.com/renew.php?renew_ID=&ID&

If there is any problem with your query please call
during office hours or email Site.com

---

And this is a script wich I run through crontab:

---

session_start();
$d = db_c();

$s1 = "SELECT ID, Name, SellerID FROM Products WHERE Purchased = \"No\" AND (TO_DAYS(NOW()) - TO_DAYS(RenewDate) >= ".RENEW_DELAY.")";
$q1 = db_q($s1);
while($r1 = db_r($q1)){
	$renew[$r1["ID"]]=array(
			"ID"	=> $r1["ID"],
			"SellerID" => $r1["SellerID"],
		                "Name"	=> $r1["Name"]
		);
}

foreach($renew as $k1=>$v1){
	$s2="SELECT Name, Email FROM Accounts as a LEFT JOIN SellerAccount as sa ON a.ID=sa.AccountID WHERE sa.ID=".$v1["SellerID"];
	$r2=db_r(db_q($s2));
	$seller=$r2["Name"];
	$mail=$r2["Email"];

	$lines = file(EMAIL_RENEW_SELLER);
	$out = "";
	foreach($lines as $k => $v) {
		$out.= $v;
	}

	$email="";		
	$email.= $out;
	$email = str_replace("&NAME&", $seller, $email);
	$email = str_replace("&PRODUCT&", $v1["Name"], $email);	
	$email = str_replace("&ID&", $v1["ID"], $email);
	if($email!=""){ mail("$mail", "", $email); }
}

db_d($d);	

exit;

But What I want it's to send all the products with there links on the same email

[leatherback]

do something like:

$query = "

SELECT * FROM Products
LEFT JOIN account on products.SellerID = SellerAccouint.AccountID
LEFT JOIN SellerAccount as sa ON a.ID=sa.AccountID 
 WHERE Purchased = \"No\" AND (TO_DAYS(NOW()) - ID TO_DAYS(RenewDate) >= ".RENEW_DELAY." order by sellectaccount.accoundid)";

while($row = mysql_fetch_array($result))
  {
   if($old_id <> $row[AccountID])
        {
       if($old_id <> -1)
           {
          // send email
            }
         $old_id <> $row[AccountID]
       }
   else
        {
        $productlis .= $row[product];
         }
  }

ps: this will have typos etc. It is the idea, not the actual code that matters

[LoganK]

Leatherback, what is "<>". I know it is "not equal to" in Visual Basic, but in PHP we use "!="...unless that's PHP5?

[leatherback]

Dearest LoganK,

read the manual and you will be surprised.
When there are 16 ways to skin a cat, I like the 17th best.

[LoganK]

Well, whaddya know? You learn something new everyday! 😉

[leatherback]

Yeah,

what can I say. I prefer to read the manual over asking, and then you stumbke across some things. Also, since in most prog. languages <> is a very acceptable form.. I use it in PhP too.