I'm still not getting anywhere on this so I've attached the latest code to see if you could take a look at it. I think I have everything in the correct order but I'm just not sure.
1) I'm trying to use the value from $totalRows_emailLookup to validate the email address to be sure they've registered and the email address is in the database.
2) There's another database on the page that has all the registered users basic contact info in it and I'm trying to pass that through to another database through hidden fields. I'm trying to use $totalRows_emailLookup again to select the row within that contact database. I've got the rs filter set to filter the e-mail address column, server variable with the value of $totalRows_emailLookup. Will this work or do I need to use a session variable or something else?
I'm also using the $totalRows_emailLookup var for the validation and the "show If" validation so again I'm not sure if this is correct.
One line I keep wondering about is this one:
$WAFV_Errors .= WAValidateNM($totalRows_rs_emailLookup_members . "",-1,0,"",",.",false,14);
In other threads I've seen this has been set to true. I tried switching it to true but it didn't work but I still wonder about it.
Currently the page must be letting any e-mail address go through because I get the error "member_id can't be null" so it seems to me that it must be trying to insert but it hasn't found the row of data in $totalRows_emailLookup
More than ever I really appreciate your help.