Email notification on specific criteria

[komlos]

Hi,

I'm struggling with this for days now. Could anyone help me? I have the below code that I run daily, and which sends notification mail to members if there is an ad in the "ad" table that matches specific criteria saved in "notice" table. Works like the feature on job sites.

But this code sends every matching ad in separate mail. What do I need to modify in this code to make it send one email per member with the ads listed in it like:

Subject of ad 1
Link for ad 1

Subject of ad 2
Link for ad 2

Subject of ad 3
Link for ad 3

.
.
.

etc.

Thanks for your help guys!

   $day = $time - 3600 * 24;
   $oneday = mysql_query("SELECT * FROM $ads_tbl WHERE add_date>$day") or error(mysql_error());
	$i = 1;
	while($rowday = mysql_fetch_array($oneday))
	{
		$ad_id = $rowday['ad_id'];
		$biztype = $rowday['biztype'];
		$subject = $rowday['subject'];
		$descript = $rowday['descript'];
		$cat_id = $rowday['cat_id'];
		$territory = $rowday['territory'];

	$terr1 = explode(", ", $territory);
	$qstring ="AND (";

	foreach($terr1 as $temp1)
	{
		$qstring .= " territory LIKE '%".$temp1."%' ";
		$qstring .= "OR";
	}

	$qstringend = ")";
	$qstring2 = substr($qstring, 0, -3);

	$qry = "SELECT email, territory FROM $notice_tbl
			WHERE biztype='$biztype'
			AND cat_id='$cat_id'
			$qstring2
			$qstringend";

	$notice = mysql_query($qry);

	while($rowmail = mysql_fetch_array($notice))
	{
		$from = "New Ad Notice <$ADMIN_EMAIL>";
		$to = $rowmail['email'];
		$mailsubject = "New ad listing from $ADVT_NAME";
		$body = "Dear Member,
This is a new ad from $ADVT_NAME

$subject
{$ADVT_URL}/ads/view.php?id=$ad_id
";
		sentMail($from, $to, $mailsubject, $body);  	

	}

}

[mojodojo]

What you have to do is take the function that sends your mail out of the while loop. You could probably do all of that for the from, to and subject line also(they all just get reset to the same thing anyway). What you would do for the message is start it above your while statement with whatever you want it to say at the top of the body. Then in the loop...

$body="Dear Member,
This is a new ad from".$ADVT_NAME ;

While($row=mysql_fetch_array($notice){

$body.=$row['field1']."<br>";//put whatever formatting you need here to space your job desc out.

}

sentMail($from, $to, $mailsubject, $body);

notice the ".=". That appends new values to the old value.

[komlos]

Thanks. I did as you instructed but the result was the same as before, except now it doesn't even print the $to variable. (I echoed the $to instead of SentMail function, for testing)

I want it to go through each member in notice table and send one email (with all the matching ads) per every member whose criteria in notice table matches fields in ads table.
(Some members has multiple rows in notice table with the same email address. )

Thanks