Need to verify custom email field to system email field

Hi again

Have followed the video but am unable to get it to work.

This is what I have tried :-

SELECT `email` FROM `#__users` WHERE `cb_email` = '[value]'

Also have attached my settings for the field



Could you please advise the correct statement.

The query validation should be added to the cb_email field. [value] is the value the user input into the cb_email field. Your current query is throwing a fatal error because cb_email does not exist in _users and can never work. So you need to check it against the _users email column as follows.

Still cannot get it to verify

Recapping what I am trying to do

At registration verify custom email field to the system email field


CB Query field setting in custom email field


Please advise

Thanks

Wait, why are you trying to use a second field to verify the primary email address field? That functionality is built into every email field and turned on under the validation parameters. That query validation only works on the field you've directly configured it on. It takes the value the user has supplied to the field you've configured the query validation on and sends it through the query as per your conditions. You've it then set to be valid if it returns no results.

Hi Kyle

My original question was at the start of this was "is it possible to verify a custom email field that I have created to the main system email field and if so how is it done. I know that the verify email field can be enabled but it needs to be verified to the system email not the custom one."
I also mentioned why I had to do that as well.
So my question again is, is it at all possible to do?

Thanks

Ah, I understand what you're trying to do. You want your custom email field to be verified against the primary email address field to ensure it's a completely different email address. Sorry, misunderstood what you were trying to do. No there's no validation rules for doing that.