Insert into multiple tables

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!

Insert into multiple tables

Guest 12 Mar, 2008

Hi,

Is it possible to modify the auto-generated code to insert the form data into two or more db tables?

I was hoping to send a few of the posted fields into a seperate table (within same db) with a second INSERT statement in the autogenerated code.

I tried making the two inserts with code that works directly in SQL but it didn't insert into either table through the form. The form did post the fields and upload a file though so it's must be the query breaking down.

Thanks

Chris

GreyHead 12 Mar, 2008

Hi Chris,

Yes ***If you know what you are doing*** you can edit the Autogenerated tab as much as you like. All that ChronoForms does is to execute the code in the tab.

Bob

Guest 12 Mar, 2008

Great, thanks for that.

Chris

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