Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Multiple MySQL Table Update on form submit?

View all replies to this thread

Multiple MySQL Table Update on form submit?

Thread began 2/01/2011 3:18 pm by 0001421801 | Last modified 2/04/2011 2:09 pm by 0001421801 | 1572 views | 5 replies

2/01/2011 3:18 pm0001421801

Multiple MySQL Table Update on form submit?

I have a problem I'm sure someone does every day, but I need to know if DataAssist server behavior or maybe another package can do this.

I have a student form that I submit.. the students are in one table, their parents / care givers are in another table. I need to be able to send the student data to the student table, get back the student ID, send the caregiver names to the caregiver table, get back the new caregiverID, and then update the table that assigns that caregiver to student.

I have several students that overlap caregivers. I need to be able to add maybe 6 caregivers to each student on this submit..

So all that happens when I hit submit.. hopefully..

I see that all that is mentioned is multiple record inserts, but not multiple table inserts?

help!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.