Pass user ID email

On my confirm.php page, I have a recordset that looks for the unique key passed by the email link. If it finds that it presents the "congrats" message, updates the record to be active, and then sends an email with the user's details to the site owner. I have the email set up using the Block template with a recordset, but I don't understand how to pass the ID of the user to that page. How do I do that?

I've attached my confirm.php and email (block template) page.

Thanks again - Joe

you dont need the recordset on the template page, you are already using the recordset on the confirm page to send the email.


On the template, you have already defined the globals:

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

So to output a value from the recordset, you would use:
<?php echo($RecipArray[$RecipIndex][0]["emailAddress"]); ?>

Well, I'm getting something, just not the values entered in the db. I'm getting the letter "j" for each call to the database. So, where I expect contact.firstname contact.lastname (with a space in-between), I get "jj". For email, it's just "j".

To recap, I put the following code at the top of my block template:

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

Here's what I'm using for the two email rows:

<tr>
<th style="font-family: 'Times New Roman', Times, serif; font-size: 10px;width: 134px; text-align: right; padding: 3px 10px 3px 3px; color: #666; font-weight: bold;">Name:</th>
<td style="font-family: 'Times New Roman', Times, serif; font-size: 10px;padding: 3px; border-left: 1px solid #DDD; color: #B6B6B6;"><?php echo($RecipArray[$RecipIndex][0]["firstname"]); ?> <?php echo($RecipArray[$RecipIndex][0]["lastname"]); ?></td>
</tr>
<tr>
<th style="font-family: 'Times New Roman', Times, serif; font-size: 10px;width: 134px; text-align: right; padding: 3px 10px 3px 3px; color: #666; font-weight: bold;">Email:</th>
<td style="font-family: 'Times New Roman', Times, serif; font-size: 10px;padding: 3px; border-left: 1px solid #DDD; color: #B6B6B6;"><?php echo($RecipArray[$RecipIndex][0]["emailAddress"]); ?></td>
</tr>

I only have one recordset on the confirm.php page with the UE function.

I've attached both confirm.php and my email template. Hope you can help.

Thanks - Joe

ok, i see, it looks like your not using a recordset loop, so in the tempalte file, changethe globals decalration to:


<?php
global $rsConfirm;
global $row_rsConfirm;
?>


und use this code to write the first and last name:
<?php echo($row_rsConfirm['firstname']); ?> <?php echo($row_rsConfirm['lastname']); ?>

That did the trick! Thanks for all your help, Jason.