form submission data sent to 2 or more tables?
-
Hi All, We’re using Form Maker MySQL mapping to send Form Maker submission to our own mysql table. We use
INSERT INTO users (
first_name
,last_name
,phone
,email
,gender
,age
) VALUES (“{1}”, “{4}”, “{7}”, “{6}”, “{2}”, “{3}”)We now want to send the form submission data to 2 different tables. Is this possible? I don’t think it is but I need to confirm this.
I tried
INSERT INTO users (
phone
,email
,gender
,age
) VALUES (“{7}”, “{6}”, “{2}”, “{3}”);
INSERT INTO users02 (first_name
,last_name
) VALUES (“{1}”, “{4}”);But it didn’t work (I didn’t think it would). Any way to do this? Thanks,
- The topic ‘form submission data sent to 2 or more tables?’ is closed to new replies.