Email

[mark110384]

Hey guys, I'm trying to email a table created from an array, any suggestions on how I can do that, at present the email is sent the number of times that a record is found, for exaple three records will generate three emails. Any suggestions would be appreciated.

[bobinindia]

sounds like the mail() function is inside your while loop.

[mark110384]

Yeah, but when I put the mail() function outside the loop it only post an email with the details regarding the last record

[bobinindia]

You will need to store the info for the table in a variable which gets a new name each while loop. ie ++1 onto each variable name.

Then join them before mailing.

each variable  hold a row.

$variable1.$variable2 etc

 

[bobinindia]

post the code.

it will be quicker

[mark110384]

Here you go guys,

 

          $result = mysql_query($sql);

 

while($myrow = mysql_fetch_array($result))

{

$itemId = $myrow['itemId'];

$price = $myrow['price'];

$quantity = $myrow['qty'];

$date = $myrow['date'];

 

 

 

$mailcontent = "Item Id: ".$itemId."\n"

  ."Quantity: ".$quantity."\n"

  ."Date: " .$date."\n"

          ."Customer email: ".$email."\n"

        ."Shipping Address: \n" .$shipadd."\n";

 

 

 

}

 

mail($to, $subject, $mailcontent,$additional_headers);

 

 

//at present it post the last result

[bkiatenxi]

why did you put the mail() outside the while loop?

[mark110384]

When the mail() function is in the loop, it will send out an email with regard to how many records are found, for example if three records are found then the email will be sent three times.

[bobinindia]

$i = 1;

while($myrow = mysql_fetch_array($result))
                     {
                        $itemId = $myrow['itemId'];
                        $price = $myrow['price'];
                        $quantity = $myrow['qty'];
                        $date = $myrow['date'];
               
                        
                     
                     $mailcontent.$i = "Item Id: ".$itemId."\n"
                                ."Quantity: ".$quantity."\n"
                                ."Date: " .$date."\n"
                                        ."Customer email: ".$email."\n"
                                   ."Shipping Address: \n" .$shipadd."\n";
                               
                     $i++;
                                                        
                        }
$mailcontent = $mailcontent1.$mailcontent2.$mailcontent3;
//etc
mail($to, $subject, $mailcontent,$additional_headers);

 

Something along those lines.

No expert myself!!

[mark110384]

Thanks, tried that but doesn't to mail anycontent now

[bobinindia]

There is no email variable being made.

You need a query that selects all items with the same email address and then make at table with the results in it.

[.josh]

$result = mysql_query($sql);
               
                  while($myrow = mysql_fetch_array($result))
                     {
                        $itemId = $myrow['itemId'];
                        $price = $myrow['price'];
                        $quantity = $myrow['qty'];
                        $date = $myrow['date'];
               
                        
                     
                     $mailcontent.= "Item Id: ".$itemId."\n"
                                ."Quantity: ".$quantity."\n"
                                ."Date: " .$date."\n"
                                        ."Customer email: ".$email."\n"
                                   ."Shipping Address: \n" .$shipadd."\n";
                               
                     
                                                        
                        }
                        
      mail($to, $subject, $mailcontent,$additional_headers);

[mark110384]

Hey thanks for the input guys but Ive found a soloution to the problem

 

$i = 1;

$mailcontent = "";

while($myrow = mysql_fetch_assoc($result))

{

$itemId = $myrow['itemId'];

$price = $myrow['price'];

$quantity = $myrow['quantity'];

$date = $myrow['createdate'];

 

if ($i ==1){

$mailcontent = "Date:" . $date."\n"

  ."Customer Email: " . $email . "\n"

  ."Shipping Address: " . $shipadd."\n\n";

  }

$mailcontent .= "Item Id: ".$itemId."\n"

  ."Quantity: ".$quantity."\n\n";

 

$i++;

 

 

}

 

mail($to, $subject, $mailcontent,$additional_headers);

}

[.josh]

ummm...i don't really see how what you've done will work. your previous $mailcontent is still being written over every single loop iteration. 

 

Did you try my code? You said that everything works fine except all you're getting is the info from the last loop. That's because your overwriting the data every single time. All I did to that code was add a dot before the = in your $mailcontent assignment, so it concats the new info onto the previous info...which is what you 1/2 did right there.  You broke it up and used the dot but on the next loop iteration, your first = will just overwrite it.

[mark110384]

Yeah it works, I get the required number of records back, to be honest I didn't even spot the dot that you put in the coding, perhaps if i'd seen it I would have gotten to the soloution faster, thanks anyway.