I have my DB connectivity enabled, and I'm writing to 2 tables.
When I originally set up my form, I was only writing to 1 table and it worked fine. When I add the 2nd table, no matter what I do, I can't get the write to the 2nd table to work properly.
I have tried 2 approaches to get this to work.
1 - I've added php sql query code to write to the 2nd table after the email is sent. This works okay EXCEPT I get a "Warning: implode() [function.implode]: Invalid arguments passed" error after I hit the 'submit' button If it wasn't for the error message this would be a good solution.
2 - I remove the php sql query code, add a hidden field to my form with the exact name of the field in the 2nd table with the input value I want. This gives this error: "store failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use" I am using 2 hidden fields that write to the 1st (original) table and everything works fine.
Does anyone have suggestions on how I can get this issue resolved?
Thanks.
When I originally set up my form, I was only writing to 1 table and it worked fine. When I add the 2nd table, no matter what I do, I can't get the write to the 2nd table to work properly.
I have tried 2 approaches to get this to work.
1 - I've added php sql query code to write to the 2nd table after the email is sent. This works okay EXCEPT I get a "Warning: implode() [function.implode]: Invalid arguments passed" error after I hit the 'submit' button If it wasn't for the error message this would be a good solution.
2 - I remove the php sql query code, add a hidden field to my form with the exact name of the field in the 2nd table with the input value I want. This gives this error: "store failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use" I am using 2 hidden fields that write to the 1st (original) table and everything works fine.
Does anyone have suggestions on how I can get this issue resolved?
Thanks.