Including recordset in body of email message

I have a page which is filtered by a recordset based on a URL parameter of a field called ID. The recordset is filtering correctly and I have set up universal email. However, it's not connecting to the recordset and I'm not sure how to go about that? The email is being sent with nothing in the body. Is there some documentation you can point me to? Thanks!

p.s. The trigger is set to Recordset: getEmail is not empty

see the following post for details:
showthread.php?t=17869

Jason, I added this to the top of my page, per the article

<?php
global $RecipArray;
global $RecipIndex;
?>

and added this code in the body of my email, replacing the field name with the appropriate field names.

<?php echo($RecipArray[$RecipIndex][0]["[yourColumnName]"]); ?>

It's still sending a blank email.

you need to replace:
"[yourColumnName]"

with the name of your columns from the recordset. for example, if one of the recordset columns is named "firstName"


the code should be:

<?php echo($RecipArray[$RecipIndex][0]["firstName"]); ?>

That's exactly what I did.

<?php echo($RecipArray[$RecipIndex][0]["fname"]); ?> <?php echo($RecipArray[$RecipIndex][0]["lname"]); ?>

etc.

can you send a copy of your pages please.

I think this is all you need. Please see attached.

you have the recordset code inside of a loop that goes through the FORM post, but you do not have a form for this email.

change this code:

<?php

foreach( $_POST as $pkey => $pval ){

  if (!RemoveValue($pkey,$remove,$removeBegins,$removeEnds,$removeIncludes))  {

?>

                    <tr valign="top">

                        <th style="font-size: 12px; width: 134px; text-align: right; padding: 3px 10px 3px 3px; font-weight: bold;"><?php echo(str_replace("_"," ",$pkey)); ?>:</th>

                        <td style="font-size: 12px; padding: 3px;">

                        <?php echo(str_replace("\n","<BR />",(is_array($pval)?implode(", ",$pval):$pval))); ?>



<?php echo($RecipArray[$RecipIndex][0]["[fname]"]); ?> <?php echo($RecipArray[$RecipIndex][0]["[lname]"]); ?>                        

                        </td>

                    </tr>

<?php

  }

}

?>

to:

<tr valign="top">

                        <th style="font-size: 12px; width: 134px; text-align: right; padding: 3px 10px 3px 3px; font-weight: bold;"><?php echo(str_replace("_"," ",$pkey)); ?>:</th>

                        <td style="font-size: 12px; padding: 3px;">

                        <?php echo(str_replace("\n","<BR />",(is_array($pval)?implode(", ",$pval):$pval))); ?>



<?php echo($RecipArray[$RecipIndex][0]["[fname]"]); ?> <?php echo($RecipArray[$RecipIndex][0]["[lname]"]); ?>                        

                        </td>

                    </tr>

Sorry, still not working. This is what the email looks like now:

Information Submitted: 10-5-2011 | 3:44 PM MST
: Signer's Name: s s
s
s
s, s s
s
s

I have no idea where the s is coming from. It's not in any field values.