Skip to Content Skip to Menu

🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

Custom validation against table

13 years 7 months ago - 13 years 7 months ago #164236 by CalvinMcGee
Custom validation against table was created by CalvinMcGee
I have the following table:
Code:
academy_validation ( id INT(11) PRIMARY KEY AUTO_INCREMENT, valid_key VARCHAR(128), start_date DATE, end_date DATE, user_key INT(11) )

Upon registration i want a field, Validation Code. I want the validation to check the entered value against academy_validation.valid_key where user_key IS NULL. If validated updates academy_validation.user_key with user id. When viewing profile I want to show academy_validation.valid_key, academy_validation.start_date and academy_validation.end_date.

How to achieve this?

Oh, and I'm using CB 1.4, J 1.6.
Last edit: 13 years 7 months ago by CalvinMcGee.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum