Guest User

Untitled

a guest
Jan 7th, 2018
351
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. %%[
  2. SET @Email = AttributeValue("Email")
  3. SET @ProductDetails = LookUpOrderedRows("LookUpDE", 0, "Product ASC", "Email", @Email)
  4. SET @CountPD = RowCount(@ProductDetails)
  5.  
  6. IF @CountPD > 0 THEN
  7. FOR @i = 1 to @CountPD DO
  8. SET @Row = Row(@ProductDetails, @i)
  9. SET @Product = Field(@Row, "Product")
  10. SET @NumberOfPoints = Field(@Row, "NumberOfPoints")
  11.  
  12. /* YOUR HTML TABLE BELOW */
  13. ]%%
  14.  
  15. %%=v(@Email)=%%
  16. %%=v(@Product)=%%
  17. %%=v(@NumberOfPoints)=%%
  18. %%[
  19. NEXT @i
  20. ELSE
  21. SET @message = "There is no product details"
  22. ENDIF
  23. ]%%
  24.  
  25. ------------------------------------------------------------
  26. Email | Product | NumberOfPoints
  27. ------------------------------------------------------------
  28. [email protected] | Mastercard | 12345
  29. [email protected] | Visa | 999
Add Comment
Please, Sign In to add comment