nested repeat region - multiple email recipients

basically i'm trying send email made of dynamic table email recipients (5-20) database table.

this seemed right way it, doesn't work correctly. first email sent correctly first email recipient. second email sent second recipient, without of dynamic table.

 

my question is: how make dynamic info gets sent every person. there better way have "send email" function repeat?

 

it feels i'm close working solution, have been struggling few hours without making progress. appreciated!

 

 

         <?php { ?>
<?php
  $sectemailobj = new tng_emailpagesection();
  $sectemailobj->getcssfrom(__file__);
  $sectemailobj->setto("{grain_closing_bids.email}");
  $sectemailobj->setfrom("grain@bartlettco-op.com");
  $sectemailobj->setsubject("closing grain bids");
  $sectemailobj->setformat("html/text");
  $sectemailobj->setencoding("iso-8859-1");
  $sectemailobj->setimportance("normal");
  $sectemailobj->begincontent();
?>
      <p>here's today's closing grain bids.</p>
      <table width="400" border="0" cellpadding="3" cellspacing="0">
          <tr>
            <td></td>
            <td><h5><strong>nearby price</strong></h5></td>
            <td><h5><strong>price change</strong></h5></td>
            <td><h5><strong>price on</strong></h5></td>
            <td><h5><strong>new crop</strong></h5></td>
          </tr>
              <?php { ?>
                <tr>
                  <td><?php echo $row_grain['title']; ?></td>
                  <td>$<?php echo $row_grain['price']; ?></td>
                  <td><?php echo $row_grain['price_change']; ?></td>
                  <td><?php echo $row_grain['price_on']; ?></td>
                  <td>$<?php echo $row_grain['new_crop']; ?></td>
                </tr>
                <?php } while ($row_grain = mysql_fetch_assoc($grain)); ?>
        </table>
      <?php
  $sectemailobj->endcontent();
  $sectemailobj->execute();
?>                <?php } while ($row_grain_closing_bids = mysql_fetch_assoc($grain_closing_bids)); ?>

bump. keep banging head against this. have ideas?

More discussions in PHP Application Development (read only)

adobe