Forums

ChronoForms v8 is now WordPress ready, ChronoMails is out

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
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

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.