mail () breaks loop

[Eric Culus]

I seem to be having troubles with this page....
It's an automated mailing script...
Steps:
- system checks on x dates the variables linked to a maintenance
contract (query on db)
- when variable matches given element is queries the db again to
retrieve the contact data linked to the maintenance system
- I then sends an email to the different contacts linked to that
maintenance contract
- then the script schoul continue looping to the next maintenance
contract
BUT: somehow, the script stop after sending the first email.
Why?
<?
// global variables
require("DbConnect.class.php");
// -------------- calculate dates ------
$yearNow = date(Y);
$monthNow = date(m);
//$monthNow = 12;
$dayNow = date(d);
$now = date(Ymd);
$mydateBeginMonth = date("Ym01");
$mydateHalfMonth = date("Ym15");
$monthPlusOne = $monthNow + 1;
$monthPlusTwo = $monthNow + 2;
$yearPlusOne = $yearNow;
$yearPlusTwo = $yearNow;
// ------------------------- Plus 1
month ------------------------------------
//
---------------------------------------------------------------------------
// December = NOW
if ($monthPlusOne == 13){
$monthPlusOne = "01";
$yearPlusOne = $yearNow + 1;
}
$myDatePlusOneBeginMonth = $yearPlusOne."".$monthPlusOne."01";
$myDatePlusOneHalfMonth = $yearPlusOne."".$monthPlusOne."15";
// ------------------------- Plus 2
months ------------------------------------
//
---------------------------------------------------------------------------
// November = NOW
if ($monthPlusTwo == 13){
$monthPlusTwo = "01";
$yearPlusTwo = $yearNow + 1;
}
// December = NOW
if ($monthPlusTwo == 14){
$monthPlusTwo = "02";
$yearPlusTwo = $yearNow + 1;
}
$myDatePlusTwoBeginMonth = $yearPlusTwo."".$monthPlusTwo."01";
$myDatePlusTwoHalfMonth = $yearPlusTwo."".$monthPlusTwo."15";
echo $mydateBeginMonth." - ".$mydateHalfMonth."<br><br><hr><br>";
echo $myDatePlusOneBeginMonth." -
".$myDatePlusOneHalfMonth."<br><br><hr><br>";
echo $myDatePlusTwoBeginMonth." -
".$myDatePlusTwoHalfMonth."<br><br><hr><br>";
//************************************************** *****************
$db->open() or die($db->error());
$db->query("SELECT maintenanceRefNumber, endDate, contactIDdistributor,
contactIDreseller, serialID, endUserID FROM TBL_maintenance ORDER BY
endDate
ASC") or die($db->error());
$i = 1;
while ($row=$db->fetcharray()) {
$maintenanceRefNumber = $row[0];
$endDate = $row[1];
$contactIDdistributor = $row[2];
$contactIDreseller = $row[3];
$serialID = $row[4];
$endUserID = $row[5];
//echo "$i - $maintenanceRefNumber - $endDate<br>";
list($day, $month, $year) = explode(".", $endDate);
$myMaintenanceDate = $year."".$month."".$day;
if (($myMaintenanceDate >= $mydateBeginMonth) && ($myMaintenanceDate <
$mydateHalfMonth)) {
// ----------------- GET DATA
----------------------------------------
//
-------------------------------------------------------------------
$db->query("SELECT tbl_product.productNaam,
tbl_product.productVersie,
tbl_product.productType FROM tbl_product, tbl_serials WHERE
(tbl_serials.serialID = $serialID) AND (tbl_serials.productID =
tbl_product.productID)") or die($db->error());
while ($row2=$db->fetcharray()) {
$productNaam = $row2[0];
$productVersie = $row2[1];
$productType = $row2[2];
}
$db->query("SELECT email, mailings FROM tbl_contacts WHERE contactID
=
$contactIDdistributor") or die($db->error());
while ($row3=$db->fetcharray()) {
$distrimail = $row3[0];
$distrmailok = $row3[1];
}
$db->query("SELECT email, mailings FROM tbl_contacts WHERE contactID
=
$contactIDreseller") or die($db->error());
while ($row4=$db->fetcharray()) {
$dreselmail = $row4[0];
$reselmailok = $row4[1];
}
$db->query("SELECT email, mailings, companyName, firstName, lastName
FROM
tbl_contacts WHERE contactID = $endUserID") or die($db->error());
while ($row5=$db->fetcharray()) {
$endusmail = $row5[0];
$endusmailok = $row5[1];
$companyName = $row5[2];
$firstName = $row5[3];
$lastName = $row5[4];
}
//mail
$subject = "Maintenance Renewal: $maintenanceRefNumber";
$message = "Dear Madam,\nDear Sir,\n\nWe would like to inform you
that
your Maintenance contract for $productNaam $productType $productVersie
with
Maintenance Reference ID: $maintenanceRefNumber will expire on
$endDate.\n
Etc....";
$sendto = "";
// send email
if ($distrmailok == "1") {
$sendto = $distrimail;
mail($sendto, $subject, $message);
//echo $distrimail."($maintenanceRefNumber distr), ";
}
if ($reselmailok == "1") {
$sendto = $sendto.", ".$dreselmail;
mail($sendto, $subject, $message);
//echo $dreselmail."($maintenanceRefNumber resel), ";
}
$sendto = $sendto.", ".$endusmail;
mail($sendto, $subject, $message);
//echo $endusmail."($maintenanceRefNumber endus)<br>";
echo "$maintenanceRefNumber - $myMaintenanceDate - $distrimail -
$dreselmail - $endusmail<br>";
//echo "$maintenanceRefNumber - $myMaintenanceDate<br>";
}
if (($myMaintenanceDate >= $myDatePlusOneBeginMonth) &&
($myMaintenanceDate
< $myDatePlusOneHalfMonth)) {
$db->query("SELECT tbl_product.productNaam,
tbl_product.productVersie,
tbl_product.productType FROM tbl_product, tbl_serials WHERE
(tbl_serials.serialID = $serialID) AND (tbl_serials.productID =
tbl_product.productID)") or die($db->error());
while ($row2=$db->fetcharray()) {
$productNaam = $row2[0];
$productVersie = $row2[1];
$productType = $row2[2];
}
$db->query("SELECT email, mailings FROM tbl_contacts WHERE contactID
=
$contactIDdistributor") or die($db->error());
while ($row3=$db->fetcharray()) {
$distrimail = $row3[0];
$distrmailok = $row3[1];
}
$db->query("SELECT email, mailings FROM tbl_contacts WHERE contactID
=
$contactIDreseller") or die($db->error());
while ($row4=$db->fetcharray()) {
$dreselmail = $row4[0];
$reselmailok = $row4[1];
}
$db->query("SELECT email, mailings, companyName, firstName, lastName
FROM
tbl_contacts WHERE contactID = $endUserID") or die($db->error());
while ($row5=$db->fetcharray()) {
$endusmail = $row5[0];
$endusmailok = $row5[1];
$companyName = $row5[2];
$firstName = $row5[3];
$lastName = $row5[4];
}
//mail
$subject = "Maintenance Renewal: $maintenanceRefNumber";
$message = "Dear Madam,\nDear Sir,\n\nWe would like to inform you
that
your Maintenance contract for $productNaam $productType $productVersie
with
Maintenance Reference ID: $maintenanceRefNumber will expire on
$endDate.\n
Etc...";
$sendto = "";
// send email
if ($distrmailok == "1") {
$sendto = $distrimail;
//mail($sendto, $subject, $message);
//echo $distrimail."($maintenanceRefNumber +1/+2 distr), ";
}
if ($reselmailok == "1") {
$sendto = $sendto.", ".$dreselmail;
//mail($sendto, $subject, $message);
//echo $dreselmail."($maintenanceRefNumber +1/+2 resel), ";
}
if ($endusmailok == "1") {
$sendto = $sendto.", ".$endusmail;
mail($sendto, $subject, $message);
//echo $endusmail."($maintenanceRefNumber +1/+2 endus)<br>";
} else {
$sendtoOrder = "[e-mail]";
$message = "TESTTESTTESTETESTE\nPlease forward message to
ECU\n\nFollowing Maintenance needs to be renewed automatically:
$maintenanceRefNumber\nYour contact is $companyName\n$firstName
$lastName\n$endusmail.";
mail($sendtoOrder, $subject, $message);
mail($sendto, $subject, $message);
}
echo "$maintenanceRefNumber - $myMaintenanceDate - $distrimail -
$dreselmail - $endusmail<br>";
//echo "------ +1 ------ $maintenanceRefNumber -
$myMaintenanceDate<br>";
}
if (($myMaintenanceDate >= $myDatePlusTwoBeginMonth) &&
($myMaintenanceDate
< $myDatePlusTwoHalfMonth)) {
$db->query("SELECT tbl_product.productNaam,
tbl_product.productVersie,
tbl_product.productType FROM tbl_product, tbl_serials WHERE
(tbl_serials.serialID = $serialID) AND (tbl_serials.productID =
tbl_product.productID)") or die($db->error());
while ($row2=$db->fetcharray()) {
$productNaam = $row2[0];
$productVersie = $row2[1];
$productType = $row2[2];
}
$db->query("SELECT email, mailings FROM tbl_contacts WHERE contactID
=
$contactIDdistributor") or die($db->error());
while ($row3=$db->fetcharray()) {
$distrimail = $row3[0];
$distrmailok = $row3[1];
}
$db->query("SELECT email, mailings FROM tbl_contacts WHERE contactID
=
$contactIDreseller") or die($db->error());
while ($row4=$db->fetcharray()) {
$dreselmail = $row4[0];
$reselmailok = $row4[1];
}
$db->query("SELECT email, mailings, companyName, firstName, lastName
FROM
tbl_contacts WHERE contactID = $endUserID") or die($db->error());
while ($row5=$db->fetcharray()) {
$endusmail = $row5[0];
$endusmailok = $row5[1];
$companyName = $row5[2];
$firstName = $row5[3];
$lastName = $row5[4];
}
//mail
$subject = "Maintenance Renewal: $maintenanceRefNumber";
$message = "Dear Madam,\nDear Sir,\n\nWe would like to inform you
that
your Maintenance contract for $productNaam $productType $productVersie
with
Maintenance Reference ID: $maintenanceRefNumber will expire on
$endDate.\n
Etc...";
$sendto = "";
// send email
if ($distrmailok == "1") {
$sendto = $distrimail;
//mail($sendto, $subject, $message);
//echo $distrimail."($maintenanceRefNumber +1/+2 distr), ";
}
if ($reselmailok == "1") {
$sendto = $sendto.", ".$dreselmail;
//mail($sendto, $subject, $message);
//echo $dreselmail."($maintenanceRefNumber +1/+2 resel), ";
}
if ($endusmailok == "1") {
$sendto = $sendto.", ".$endusmail;
mail($sendto, $subject, $message);
//echo $endusmail."($maintenanceRefNumber +1/+2 endus)<br>";
} else {
$sendtoOrder = [e-mail]";
$message = "TESTTESTTESTETESTE\nPlease forward message to
ECU\n\nFollowing Maintenance needs to be renewed automatically:
$maintenanceRefNumber\nYour contact is $companyName\n$firstName
$lastName\n$endusmail.";
mail($sendtoOrder, $subject, $message);
mail($sendto, $subject, $message);
}
echo "$maintenanceRefNumber - $myMaintenanceDate - $distrimail -
$dreselmail - $endusmail<br>";
//echo "------ +2 ------ $maintenanceRefNumber -
$myMaintenanceDate<br>";
}
}
?>

[Oli Filth]

Eric Culus wrote:

I seem to be having troubles with this page....
It's an automated mailing script...
Steps:
- system checks on x dates the variables linked to a maintenance
contract (query on db)
- when variable matches given element is queries the db again to
retrieve the contact data linked to the maintenance system
- I then sends an email to the different contacts linked to that
maintenance contract
- then the script schoul continue looping to the next maintenance
contract
BUT: somehow, the script stop after sending the first email.
Why?

<...SNIP 300 LINES OF CODE...>

Dude, NO-ONE is going to trawl through 300+ lines of your code to try
to figure out what's wrong.

Post a *minimal* test script, and we might be able to help...

--
Oli

[Samuel]

I agree with Oli. If you give us a "short but complete" script it will
be sooo much easier. Read this article from John Skeet to know how to
make it...

http://www.yoda.arachsys.com/csharp/complete.html

All credit to that great guy.

[Eric Culus]

Hope,

This' shorter...

<?

$db->open() or die($db->error());
$db->query("myquery") or die($db->error());
$i = 1;
while ($row=$db->fetcharray()) {
output db data

if (($myMaintenanceDate >= $mydateBeginMonth) && ($myMaintenanceDate <
$mydateHalfMonth)) {

$db->query("Start another query") or die($db->error());
while ($row2=$db->fetcharray()) {
$productNaam = $row2[0];
$productVersie = $row2[1];
$productType = $row2[2];
}

Etc... more queries until all data recovered

//mail
$subject = "mysubject";
$message = "mynessage";
$sendto = "myemail";

// send email
if ($distrmailok == "1") {
$sendto = $distrimail;
mail($sendto, $subject, $message);
}

if ($reselmailok == "1") {
$sendto = $sendto.", ".$dreselmail;
mail($sendto, $subject, $message);
}

$sendto = $sendto.", ".$endusmail;
mail($sendto, $subject, $message);
}
}

loop until next matching record found....

?>

[Mark Rees]

> <?

$db->open() or die($db->error());
$db->query("myquery") or die($db->error());
Don't know what's going on in your $db class, but do you have to assign the
result set to something?

e.g. $result=$db->query("Start another query") or die($db->error());
$i = 1;
while ($row=$db->fetcharray()) {
output db data

if (($myMaintenanceDate >= $mydateBeginMonth) && ($myMaintenanceDate <
$mydateHalfMonth)) {

$db->query("Start another query") or die($db->error());
Does this call to $db overwrite the result set you are looping on - the one
you initialise with query("myquery") ?

while ($row2=$db->fetcharray()) {
$productNaam = $row2[0];
$productVersie = $row2[1];
$productType = $row2[2];
}

Etc... more queries until all data recovered

//mail
$subject = "mysubject";
$message = "mynessage";
$sendto = "myemail";

// send email
if ($distrmailok == "1") {
$sendto = $distrimail;
mail($sendto, $subject, $message);
}

if ($reselmailok == "1") {
$sendto = $sendto.", ".$dreselmail;
mail($sendto, $subject, $message);
}

$sendto = $sendto.", ".$endusmail;
mail($sendto, $subject, $message);
}
}

loop until next matching record found....

?>

[Eric Culus]

>> $db->open() or die($db->error());

$db->query("myquery") or die($db->error());

Don't know what's going on in your $db class, but do you have to assign
the
result set to something?

No, the class is build in such a way that it is not necessary to use
"$result = "

$db->query("Start another query") or die($db->error());

Does this call to $db overwrite the result set you are looping on - the
one
you initialise with query("myquery") ?

This is a query request inside the first loop... simply pulling new data
from the db when a matching variable is found
"Mark Rees" <mr***@itsagoodprice.com> wrote in message
news:79******************@newsfe6-win.ntli.net...

<?

$db->open() or die($db->error());
$db->query("myquery") or die($db->error());

Don't know what's going on in your $db class, but do you have to assign
the
result set to something?

e.g. $result=$db->query("Start another query") or die($db->error());

$i = 1;
while ($row=$db->fetcharray()) {
output db data

if (($myMaintenanceDate >= $mydateBeginMonth) && ($myMaintenanceDate <
$mydateHalfMonth)) {

$db->query("Start another query") or die($db->error());

Does this call to $db overwrite the result set you are looping on - the
one
you initialise with query("myquery") ?

while ($row2=$db->fetcharray()) {
$productNaam = $row2[0];
$productVersie = $row2[1];
$productType = $row2[2];
}

Etc... more queries until all data recovered

//mail
$subject = "mysubject";
$message = "mynessage";
$sendto = "myemail";

// send email
if ($distrmailok == "1") {
$sendto = $distrimail;
mail($sendto, $subject, $message);
}

if ($reselmailok == "1") {
$sendto = $sendto.", ".$dreselmail;
mail($sendto, $subject, $message);
}

$sendto = $sendto.", ".$endusmail;
mail($sendto, $subject, $message);
}
}

loop until next matching record found....

?>