OTP-verify.html

%%[
ELSEIF RequestParameter("submittedOTP") == true THEN
SET @OTP = RequestParameter('OTP')
SET @email = RequestParameter("email")

/* check OTP against the DE */

set @rows = LookupOrderedRows("OTP", 1, "SentDate desc", "EmailAddress", @email)

if @rowCount > 0 then

    set @row = row(@rows, 1)
    set @deOTP = field(@row,"OTP")

endif

if @otp == @deOTP then
]%% 

OTP verified

%%[ else ]%%

OTP not vverified

%%[ endif ]%%