Thanks for the response. That error seems to have been corrected. I am now getting the same error as earlier:
'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@emaildomain.com,0)' at line 1'
I have looked at my database any all the email entries appear to be in the correct varchar format and text for the server behaviours. The email validation fields are assigned as numeric but I'm assuming this is correct.
I am really stuck with this and really would like to get this last issure resolved so I can close this project. many thanks again Jason for all your help so far.