Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Advice - SQL Custom Code or DB Save??

msreyes 24 Jul, 2020

My form reads a database to display result. From there, the user fills in other fields and I save this full record into a new table. All this works for my needs.

BUT, if the user checks a specific box (Yes = 0, No =1) I want to update the original table with this value.

Should I just put an IF condition and PHP the SQL statement? Are there any examples of PHP and SQL with chronoforms out there?

Max_admin 25 Jul, 2020

use the "if conditions" action to check the value of the checkbox and have 2 "save data" actions, one to save, another to update inside the 2 conditions!

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

msreyes 29 Jul, 2020

I think I understand... not sure... think I have it right?[file=13194]whativedone.pdf[/file]

This topic is locked and no more replies can be posted.