data from recordset not showing in email

I am using v4.01.
I added the recordset to my page then added the email. I selected the template and modified the template.
The emails are formated correctly and look good, but none of the data from my recordset is showing. Is there an extra step to get it to display correctly?

Hi Troy,

I think this three might help to point you in the right direction...

showthread.php?t=17869

Cheers
Ian

I have made the changes and it is still not sending correctly.

I have made these changes:
Replaced
Plan ID: <?php echo $row_User['ID']?><br />
PO/Plan Name: <?php echo $row_User['skPlanID']?><br />
Name:<?php echo $row_User['skUserName']?><br />
Email:<?php echo $row_User['skUserEmail']?><br />

With This
Plan ID#:<?php echo($RecipArray[$RecipIndex][0]["ID"]); ?><br />
PO/Plan Name: <?php echo($RecipArray[$RecipIndex][0]["skPlanID"]); ?><br />
Name:<?php echo($RecipArray[$RecipIndex][0]["skUserName"]); ?><br />
Email:<?php echo($RecipArray[$RecipIndex][0]["skUserEmail"]); ?><br />

The emails are going to both email addesses, but the data is different in both
The data that should be displayed is:
ID: 274
skPlanID: Troy's Set
skUserName: Troy Doe
ksUserEmail: troy@myemail.com

The first email displays:
ID: t
skPlanID: t
skUserName: t
ksUserEmail: t

The second email displays:
ID:
skPlanID: 3
skUserName:
ksUserEmail:

Thanks for your help!

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Hello,

I'm also getting "t" in my emails. I've searched the UE threads extensively for a fix but the promising ones always lead to support tickets. I attached some of the different versions of files that I tried to get to work, templates, the waue_index and the resulting email.
Thanks in advance for your time.

-Jeremy

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

If you aren't sending email to the recordset loop and you are just trying to refer to another recordset in your email body, you probably have to move back to your original format:


Plan ID: <?php echo $row_User['ID']?><br />
PO/Plan Name: <?php echo $row_User['skPlanID']?><br />
Name:<?php echo $row_User['skUserName']?><br />
Email:<?php echo $row_User['skUserEmail']?><br />


and just add this to the top of the email template:

<?php
global $row_User;
?>

Hello again,

A year ago you helped me with this in Technical Support Ticket # 140049. I've looked over the files that you helped me with back then and I can't see anything that I am doing different. The files from last year still work fine I just can't get my new project to pass any information from the recordset into my email. I would also like to do a loop around the information pertaining to the clients order, how do I go about accomplishing that once the rest of it is working?

The files I'm working with are attached, let me know if you need any thing else.

Thanks so much for your time!

your recordset is set to filter on the orderID url variable, make sure this is included in the forms action:

<form  action="ordersDetail.php?orderID=<?php echo(isset($_GET['orderID'])?$_GET['orderID']:""); ?>" name="shipEmail" method="post">

to show the order contents, add the repeat region for the order details recordset to the email template page and the bindings to show the columns from the order details recordset.

I knew I was over looking something simple.

Thank you!

In case anyone else is wondering about loops in emails, I also had to add a global for the while loop to work with.

<?php
global $row_rsOrders;
global $row_rsOrderItems;
global $rsOrderItems;
?> 
<?php do { ?>
info to loop
<?php } while($row_rsOrderItems = mysql_fetch_assoc($rsOrderItems)); ?>