CNX18-ECAS-subscriberReferrals
%%[
var @sk, @rows, @row, @rowCount, @i
set @sk = AttributeValue("_subscriberkey")
set @rows = LookupRows("SubscriberReferrals", "SubscriberKey", @sk)
set @rowCount = rowcount(@rows)
if @rowCount > 0 then
]%%
<p>Your referrals</p>
<table border="1">
<tr>
<th>Name</th>
<th>Date</th>
</tr>
%%[
for @i = 1 to @rowCount do
var @referralDate, @referralName
set @row = row(@rows, @i)
set @referralName = field(@row,"referralName")
set @referralDate = field(@row,"referralDate")
]%%
<tr>
<td>%%=v(@referralName)=%%</td>
<td>%%=FormatDate(@referralDate,"s")=%%</td>
</tr>
%%[
next @i
]%%
</table>
%%[
endif ]%%