userupdate page / using 'Double Opt In' - page error
I have adapted a registration system with the 'Double Opt In' system as per your Tutorial. There is an error with when the user clicks the verification link in the email they are sent. It re-directs to the correct page to confirm but the wrong message is being displayed which is;
"Your email verification link has expired. Click here to have a new link sent for verification"
Even though the database gets updated correctly. Any Ideas?
page is here:
https://www.lease-assn.org/emailconfirm.php
Plus the Userupdate page has an SQL error when the re-send link is clicked. This seems to be caused by the 'update' behaviour but i can't work out why.
page is here:
https://www.lease-assn.org/members/userupdate.php
Ive attached a PDF with ftp and database details.
Thanks in advance.