[SOLVED] Check if field value exists in comprofiler table

2 years 5 months ago - 2 years 5 months ago #326841 by ontarget
Hi
I have a field called "Membership number".
If a user enters a Membership number that is already in the comprofiler table I want to block their registration (much in the same way that email values cant be registered twice)
Is the possible with CB?
Do i need a special plugin?

Please Log in to join the conversation.

2 years 5 months ago - 2 years 5 months ago #326842 by ontarget
I used the CB Query add on
SELECT * FROM `jos_comprofiler` WHERE `cb_membernumber` = '[value]'
Validate on empty result
Works great!

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.398 seconds

Facebook Twitter LinkedIn