DBlookup function to final of register

I bought the professional membership, $150, because I need to validate than the input code exist in the table of database, prior to input the remain register fields. Then, continue to registration form. Otherwise, come back to homepage of my site.

But in the register form I should input the all fields and press the register button, for the validation function. I really want than the validation to realize first, and depending of resultant value, continue with the next fields or abort the register.

How do I for get this?

Of before hand,

Very thanks,
JOSE ALVARADO

You want to validate that the value they input into a field exists in the database before letting them register? If my assumption is correct then yes this is doable. You'll need to use CB Query Field and its Query Validation and a Text Field for example. Example usage of CB Query Field and its Query Validation can be found below.

www.joomlapolis.com/forum/153-professional-member-support/223186-solved-qsecuredq-registration?start=6#235806

Thanks Krileon.

Effectively, that is exact. I input in query field SELECT * FROM 'dgmd_clienteruc' WHERE ruc_cli='[value]', how testing if this evaluate to TRUE. Please show me the steps to achieve it. I´m stressed because since I bought the tool I can not even solve the problem.

The below will probably work.

Query Validation: Enabled
Query: Mode: Internal
Validate On: Successful Results
Validate Error: Invalid token provided!
Ajax Validation: Enabled

The above will validate if there is a match. I don't know your database structure so you may need to adjust the query. If you've any further issues please carefully review the link I provided above as it details a working example (including the database table).

Hi Krileon:

I created the text field and activate the query and function perfect.
Now, when already validated the query field RUC and evaluate a TRUE, continue to the form.

But before, how I show the description of the field RUC, only show, without input any data?

The SQL sentences SELECT don´t support query from 2 tables.
Please tell me any clue.

Thanks,

You want to test the value against 2 database tables? That's possible. Just do a JOIN to merge the two tables together for your select query. Example as follows.