-
lplatzAsked on October 24, 2019 at 7:02 PM
Referencing "Form to MySQL - Send form data to your MySQL Database". I'd like to post the data from my form to more that one table. Is that possible?
-
John Support Team LeadReplied on October 24, 2019 at 7:11 PM
I believe this guide my help you achieve the requirement:
How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP
Please try that and let us know how it goes.
-
lplatzReplied on October 24, 2019 at 8:20 PM
The script (in it's present form) will only insert into a single table. I've posted a question requesting the ability to modify the "How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP" script to post form data into multiple tables. Thank you for your follow-up JohnRex.
-
Jed_CReplied on October 24, 2019 at 9:09 PM
If mysql supports that functionality then it should work as Jotform only sending the POST to your mysql database, this means that whatever function is supported with your mysql version should work.
I've searched through online and found some feedback that this technically is not possible in mysql, but there are some suggestions that you can try how you can insert into multiple tables.
Reference link: https://stackoverflow.com/questions/5178697/mysql-insert-into-multiple-tables-database-normalization
Let us know if you have any questions or if you need further assistance.