Forums

Hi! i've installed and configurated a chronoforms form that store the data in the db and send email to the subscriber I've also buyed a subcription and validate chronoforms on my website
i need to check the email isn't duplicated in the database so i use this code i've bought

ChronoForms v4 How-to doc
Using Ajax : two examples
"Email checker"

i've copied and paste this code the only things i've changed are
&chronoform=my_form_name with the name of the form

and in the load javascript window

and the name of the table in the custom code window

SELECT COUNT(*)
FROM `#__users`
WHERE LOWER(`email`) = ".$db->quote($email).";

with
$query = "SELECT COUNT(*)
FROM dtyi5_chronoforms_data_mytable
WHERE LOWER('email') = ".$db->quote($email).";

but it dosn't work anymore the email isn't never accepted it becomes red but i can't submit anymore the form, could you help me??
i could send the login information to have a look
thank you

Hi gggdeveloper,

Please post a link to the form so I can take a quick look.

Bob

Hi gggdeveloper,

I think that you may have missed the opening <?php tag at the beginning of the Ajax event code block.

Bob

what a very stupid error but now it works!!! thank you