Registration process. No user yet.

Table name "country_info"


2 Fields:

a) cb_country
We use this query: SELECT DISTINCT `country` FROM `country_info` ORDER BY country
Everything shows fine! No problem to select the country.


b) cb_state
Here we need to show all states of the selected country in the previous field. So we try like this:
SELECT DISTINCT `state` FROM `country_info` WHERE `country` = '[cb_country]' ORDER BY state
No way...
The pull down field is empty.

If we change the (`country` = '[cb_country]') part of the query with (`country` = 'Andorra') for example... the field works and shows the Andorra states. So we believe that there is something wrong with the '[cb_country]' part.


Can you please advise?

Thank you in advance...

Forgive me i forgot to mention.

CB Core Fields Ajax is already installed and set but the result is no choices inside the states pull down menu.

Is this during profile edit or registration? frontend or backend?

Registration, Frontend

Ensure CB Core Fields Ajax it self is public and published in CB > Plugin Management.

Published and public!

Ensure within CB > Configuration > User Profile that "Profile View Access Level" is set to something your users can actually access as it can block ajax endpoints.

We are talking about the Registration process. No profile yet to have "Profile View Access Level"

You should see a loader icon appear next to the State field when your change the value of your Country field.

No... no loader shows when changing Country field.

What i see is this...
Before country select...


After country select...